Daily Updates from Four Tabs Based on Dates

Hi,

I inherited a weekly staffing report (on the first tab) that is updated daily from the data shown on the next four tabs. I would like the data to populate automatically. At first, I did a simple cell reference in each cell

'January HPPD - 2023'!B46


but that is extremely tedious. Then I tried to use vlookup by first changing the data in the date column on the January tab from numbers to dates. I used vlookup on the first unit on the January tab. I then realized that I would have to do a vlookup for each unit for each month. Is there an easier way to get the data to populate automatically on the first tab? Any help would be appreciated.

Thank you.