Reference Data in 2 Worksheets
 

Help !

I would like to have data that is automatically provided to be automatically
filled in for each day that a person that works.

On my new worksheet, I have a calendar with the date on top and the
following on the bottom Tech Name (B4), Start Hour (C4) and End Hours (D4).

I am currently using ='schedule'!B3, to get my data from another sheet.

On another worksheet (Schedule) , I have Date(A3), Tech Name(B3), Start
Hours(C3) and End Hours(D3). I want the Tech Name, Start Hours, and End Hours
to be filled in automatically in my new worksheet.

I hope this makes sense to all. Any help would be appreciated.

Thanks
Matt