Check with master sheet

Dear forum members,

I am have excel contains two sheets

Input sheet where users to be Type or copy paste the data under headings

Master sheet is the base sheet

My requirement is the user can enter data only which is available in master data based on details in column,

Example they cannot enter date after given date range and given region or given Manager

kindly give vba button for highlight wrongly given data

and show check data error till all data is correct

Data validation not advisable for some reasons..Provide solution in VBA

kindly do the needful