I have 7 workbooks and I want to create the 8th from the data files.
My 8th workbook would have all the data from 08-09 from each of the
sheets from the 7 - PLUS an 8th worksheet in this 8th workbook that
would combine the data so I can filter and sort it as I need to. Does
this help?

Thanks!!

On Aug 5, 3:27*pm, "Otto Moehrbach"
wrote:
From what you say, you have 8 workbooks. *One workbook, call it Total.xls,
is blank. *The headers of the other 7 workbooks are the same. *You want
these headers placed in the Total workbook, row 1, then you want all the
data, from row 2 down, from each of the 7 workbooks, placed into the Total
workbook, one after the other, going down the sheet. *Is this right? *HTH
Otto"Snailspace" wrote in message