Headcount Date Search Summary

Hi all,

First post so apologies if I'm not following the correct etiquette!

I want to create a workbook that has multiple sheets detailing annual leave and headcount for a number of offices. This bit is fine and I can do this.

I then want to create a summary front sheet that shows current headcount in the offices. In other words, I need a formula to search for the current date on the other sheets, then reference the summary cells in that date's column. I.e. today's date is 10 March 2020, so I would want the formula to search for cells with that date (let's say Sheet2!D1) then go to the summary cell for that column (let's say Sheet2!D2). Then tomorrow it would automatically reference the same cell in the column with 11 March 2020 (let's say Sheet2!E2).

Is this possible? Also, is this possible with Excel Online, which is all I have available to me at the moment?!

Any help would be hugely, hugely appreciated.

Chris

Thanks for the speedy response. I have not yet started the workbook so will put together an example and post here for clarity.

Here is a sample workbook with blank cells on the first sheet where I need the information to be. Hopefully it all makes sense but let me know if you need any more information.

Thank you so much!

Fantastic, this is perfect. Thank you so much for your help!