Arranging values from Series of Arrays in Descending Order by Formula - Not Macro

Dear Jason,

Attached is the real sheet, with personal/commercially sensitive information removed and replaced with generics to protect people/company. I wanted to avoid uploading this because (if I were reading this and trying to help) I fear it would complicate things as there is a web of formulas.

Tabs:
- 'Master Data' is the sheet containing the instructions for allocation and arrangement of data. No need to look at this.
- 'Drop Sheet' is the exported report from the external database. The report is exported from the ext. database in Excel format then 'dropped' (copy and pasted) here
- 'AssembledInformation' takes the information as per the 'DropSheet' and organises it according to the instructions contained in the 'MasterData' tab
- 'Journal' is the sheet which will eventually contain the 'AssembledInformation' data in Journal format.

With reference to the above, I want to take the data from the 'AssembledInformation' (which is spread over columns B to tab and arrange the data BU) and arrange in descending order on the 'Journal' tab.

In response to your questions:
- The results shall be sorted in order of the array i.e. if Column A is 'Chairs' and Column B is 'Fuel' one week and the next week they switch columns, it doesn't matter as they can appear in a different order in the journal. That is to say, I don't need 'Chairs' to be first on the journal list every time. Whatever appears in the first column can be first in the journal list.
- Real array attached (see tab 'AssembledInformation')
- Future data can both be added and replaced. Expense types (which are presented by column) will appear in month 1 (let's call it 'original data'). The next month (when the next monthly report is generated) additional expense types (columns) can appear alongside the original data. Likewise some original data may not appear on the next month's report but new expense types might, effectively taking the place of old expense types NB regards this point, I think I know where you're going and I'd draw your attention to the fact that in my real array, each expense/column is headed by a number, which acts as the constant (regardless of whether the expense in type in that column is the same as the orignal data). I would use these number references as oppose the expense type.


I have no problems if someone wants to implement Macros, but I would only ask that they explain to me how the specific Macro works. I haven't yet had the opportunity to explore this feature of Excel so would need a brief 101 on the subject.