Daily summary sheet that autopopulates each day.

Hello,

I am trying to create a daily summary sheet that autopopulates with the presvious days data. The sheet will draw this data from various sheets in various workbooks.

I am hoping to achieve it so that when a user opens the daily summary sheet, it displays the information from the day before and automatically does this each day when a user looks at the summary. (i.e. it only ever displays the day befores data)

Is the above possible at all and if so would anyone be able to aid me? Hopefully it is possible without macros and just some formulas as I'm not to up too speed on the macro side of things

(I have produced a simple excel file (attached) showing an example of the type of data I am using and also an example of what I am going for with the daily summary sheet.) Please excuse its simlplicity, the data I am trying to summarise is sensitive.

Any help would be greatly appreciated!

Hi MarvinP,

Thanks for getting back to me!

I have tried a pivot table, but unfortunately it doesnt quite do what I am after as, as you remark upon, I would have to display the data in a similar format to the way you have in your example. This, to my regret, is not possible.

I have quite a lot of data that I need to summarise, hence wishing to summarise it! However, I am stuck!!

Thinking about it, if someone knew how to make a cell autopopulate each day with the figure in a cell on a different sheet corresponding to the previous day. . . I could figure the rest out from there. If that made any sense??