Hi
I have a sales forecast workbook for each of 6 account managers. The headings are the same for each workbook.
I want to basically copy all of this data into a master workbook as an exact replica so I can then filter the data.
I could just copy and paste special (as the individual sheets...