Consolidate Data into one sheet

[waseemsiddique]

Hi Guys,

I have Trial Balances of different divisions with same pattern in many different sheet.
I have prepared a separate sheet which include the sum of certain codes of trial balance to make a profit & Loss A/C.
(As an example all codes in the Trial Balance in All sheet starting with Digit 40 are Sales Ledgers, and 5 are cost of sales to sum up the Total to prepare a Profit & Loss A/C).

Now I want if i could just filter in the same sheet by division name and i will automatically get the data from the relevant sheet.

3-D Reference could not be used as i don't need the sum rather i want to bring the whole TB value in that Master Sheet in predefined way.

I hope you will get my question

 

[Logit]

.
This is simpliest method : https://www.gcflearnfree.org/excel2013/filtering-data/1/