Calling all formula experts

[Fiona1981]

Hi everyone newly joined and hoping someone can help me out.  I'm creating a sort of reporting dashboard in execl, 10 tabs relating to each location inserting the data, each week, every location enters their data and I want to pull this through to a dashboard essentially using a drop down list to select the date and the figures then populate depending on what date is selected.  The problem is im stuck with the formula, would this be vlookup? Any help would be appreciated im struggling to find anything on YouTube but probably because im not exactly sure what im looking for! 

[#2]

It sounds like the FILTER function might be the way to go. It's difficult to write the formula without seeing a sample workbook.

[#3]

I would suppose to use Power Query to load data from a folder with these 10 unique data file.

Otherwise you need some function to merge all data from 10 sheets to an array,
I didn't find a proper formular works as UNION in VBA.