Dropdown list from multiple sheets

[Raphael024]

Hi there!

I'm kind of a rookie when it comes to Excel, and I am stuck with a problem which I hope somebody can advice/help me on/with. I've attached 2 screenshots of the Excel sheet, so you know what I'm talking about.

I have an Excel sheet in which I gather quarterly financial data, for 12 companies. It's 4 data points per quarter per company. Every company has a seperate sheet, and there is one summary sheet. In this summary sheet (Attachement called 'Capture 1') I would like to have an overview of all the companies and the 4 data points, filtered on a quarter selected from a dropdown list. So for example, if the user wanted to see the data for all the companies in Quarter 2 of 2022, they could select that in the dropdown list, and it would return all the data for that specific quarter. The input for this are the individual sheets per company (an example is Attachement called 'Capture 2').

Can anyone tell me if this is at all possible and if yes, how?

There is another thing that I am wondering, but this is more of an extra. Ideally, the dropdown list would also include, for example, FY 2021 (Full-Year 2021), which is all of the quarterly data for 1 year combined.


Thanks in advance for the massive help!