HI i have the following Macro which Merges multiple sheets to 3 consolidated sheets in a new workbook, bases on text within a sheet name, and also adds a column in a with the sheet name against every every item.
Dim Master As Workbook
Dim current As Workbook
Dim cases As...
I need to consolidate multiple tabs into a summary tab however they are set up differently but they all have the same account heading & country type, can anyone help with a formula or macro?
Example of tab 1