Create a master list from dynamics lists in multiple sheets.

Here is the scenario.

I have 20 different branches like e.g. Branch 01 Branch 02 ..... Branch 20. These branches are divided into 4 categories (Flagship,Standard, Mall & kiosk). A branch can be in one category at a time. Like for example Branch 01 can only be Flagship. If it changes category then it will be moved to respective sheet automatically.

Now i want to create a master table with all the branches and their respective values. Right now i am doing this manually. I have attached sample sheet. Bear in mind a brach can be classified from one category to other what i mean to say is input sheets are dynamic. So out put master sheet has to be adjusted accordingly.

Example file is attached