Daily totals from the 1st tab, are auto-populated on the 2nd tab, based on today

Hello,

Please could someone help, I was trying to find a way whereas the daily totals from the 1st tab, are auto-populated on the 2nd tab, however based the date that we are on.

It would pull through Scotland for 11/11/2021 in to it's respective cell on the 2nd tab.

Kind Regards,

Adam

Administrative Note:

Welcome to the forum.

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Not sure what the "consolidated volume" is, but guessing that for Scotland on Nov. 11th it is the sum of cells B67:C67 (167)
If that is the case then I feel that the following formula will do what you want:

Formula:

Please Login or Register  to view this content.

Note that I made changes to the format of the Daily sheet by unmerging the cells.
Let us know if you have any questions.