How to create an effective Entry Sheet in Google Sheets (3 simple steps)

In this video you will show you how to create a simple yet effective Entry Sheet in Google Sheets by :
1 - Identifying the list of columns that we want to track
2 - Setup Data Validation rules to add dropdown menus and calendar
3 - LOOKUP existing information automatically using XLOOKUP Function