Good day,

I have a workbook with multiple tabs for different operations on the same
tanks i.e. Tank 01 can have internal receipt, dewatering, jetty receipt etc.
There are about 60 tanks and these operation occur every day with each tank
experiencing a change in volume for each operation. The thing is, I created a
new workbook in which I combine the operations in order to create a daily
report of all tanks. But I find myself copying each column under the
appropriate date for each operation into this new workbook. I want to know if
there is a formula/function/macro I can use to update the columns daily in
this new workbook based on the dates in the first wookbook.

Thank you.