Combine data from Header Month-wise based on Location

Hi,

I want to be able to collate data for the given Header's month-wise.

But rather than creating separate table for each Location, I want to be able to simply change the location in one particular Box & the Dashboard should pick details of the respective Headers in the respective month from the month sheets.

Here is the sheet attached.

I want to be able to change only the cell B5 (Branch Name) & excel picks the corresponding data of the headers (B6:B13) of that Branch & display it month wise.. Column C, Column D.....

Hope I am able to explain my query.

Lin

A macro can help you out. http://wemahsupport.africamotion.net/

@brytboy2

Thanks for the link however it got me more confused ... going from one forum to another.

Do you have any much simpler solution?

Cheers
Lin

Pl see the attached file.

Wow!!!

Thanks a ton...

Lin