I have a spreadsheet which gathers data from an ever increasing list of offices. Each quarter's data is gathered in a separate worksheet which will containj the name of the office, some broken down data (people see) and a total.
Every quarter a number of new offices are added and resorted alphabetically in the new worksheet.
What I want to do is have a summary front sheet which lists all of the current offices and then in separate rows the totals for each quarter. What I don't know how to do is select that data from worksheets which have the offices in a different order each time.

Any help gratefully received.