Dropdown list from multiple sheets

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!

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Hereby the Example sheet. Can anybody let me know how I can do this, and if it is at all possible to also have Full Year numbers (so the sum of all quarters in a certain year). Thanks!

Raphael