Automatically populate a spreadsheet with raw data

I have 3 separate sheets in one workbook(Spread A) labelled Customer Visits, Admissions 1 and Admissions 2. Everyday, the Customer Visits sheet is updated with fresh data and I am trying to find a formula/method where the columns in sheets labelled Admissions 1 and Admissions 2 are populated by the new raw data from Customer Visits.
For example, the fresh data comes in to Customer Visits on January 1st and I am trying to find a method that populates the columns Day_01, Day_02, Day_03 etc... of Admissions 1 and Admissions 2. I think the best approach is Vlookup but this causes the previous day to be overwritten by the next. E.g. Day_02 overwrites Day_01.

Just wondered if anyone has come across a similar problem before?
Thanks in advance

When the "Customer Visits" sheet is updated daily, isn't the data for the previous days the same. In other words, on Day 1 you have data in for Day 1. When you get fresh data for Customer visits on the second day, isn't the same data for day 1 still there and new data is now available for day 2?

Other question - you mention Sheets "Admissions 1" and "Admissions 2", but the sheets are named "Till 1" and Till 2". Am I to assume that Sheet "Till 1" should be updated by those records on "Customer Visits" where the "StreamType" = "Admissions 1"?

If so, you could try this formula in cell G10 on Sheet "Till 1":
=SUMPRODUCT(--(Spread_B[[DESCRIPTION]:[DESCRIPTION]]=$B10),--(Spread_B[[StreamType]:[StreamType]]="Admissions 1"),Spread_B[DAY_01])

Then copy this formula down and across.

Of course if my assumptions are wrong, then forget about the formula :-)

Thank you for your reply!

In response to your first question, yes, that is correct. The data is still there for day 1 when new data comes in for day 2.

Secondly, apologies sheets 'Till 1' and 'Till 2' should be labelled 'Admissions 1' and 'Admissions 2', this has now been updated.

Finally, I tried the proposed formula and the cells do populate, however the data is populated in the wrong days and for the wrong column descriptions.

Originally Posted by Mino_B

Finally, I tried the proposed formula and the cells do populate, however the data is populated in the wrong days and for the wrong column descriptions.

Can you be more specific, and maybe upload the file. It works for me as far as I can see.