Consolidate sheets to one output sheet

[KingTamo]

Hi guys

there are 8 sheets, 2009 to 2016, these sheets have input data.

Expected sheet is the sheet which is the desired output, which should be created by a click of button from the input sheets. Also note, that in future sheets might get added, like 2017, 2018 and so on, so you have to keep in mind that also.

In expected output sheet Quarters are as follows :

Q1(Sep to Nov) , Q2(Dec to Feb), Q3(Mar to May), Q4(Jun to Aug)

K€ is the total of respective quarter
There can be blank values in some months, as the group gets added in later month and was not there in previous month.
Also, as the group account gets added , it might be present in 2010, but not in 2009 sheet, as it was introduced later

What i need is to manipulate data, which arranges data in the the expected output format.

[Olly]

Try this. It adds named ranges to each data sheet, then uses a couple of queries to transform and consolidate the data from each named range, into a table on an Output sheet:

Please Login or Register  to view this content.

[KingTamo]

Thanks a lot Olly for this awesome file and I appreciate a lot your great effort
thanks a billion for help

[Olly]

Happy to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.

[KingTamo]

Thanks again
I have added a reputation points and I appreciate a lot your great help