Enter date from one sheet to have info from other sheet with same date

[Jeorge]

I have 2 sheets with multiple tables, Sheet 1 got A1 for Jan. 1, then A7 for Jan. 2, A13 for Jan 3; On Sheet 2 I have same single table. What I wanted to have is, if I input the date Jan. 1 on Sheet2 then it will give me the table for Jan. 1 from Sheet1, if I change it to Jan. 2 then table for Jan. 2 will appear. Please see image attached.

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-fo...ave-info-from-other-sheet-with-same-date.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Jeorge]

I am sorry if I made that cross posting error, not familiar with that, I was also advised from excel forum regarding this but in a very different unpleasant way and thankful on how you handle my post. Thank you I will post it differently thanks