This page might help:

http://www.contextures.com/xlPivot08.html#Create


HTH,
JP


On Apr 15, 7:24*pm, robzrob wrote:
I've got 6 workbooks, each containing 1 worksheet. *6 users each enter
rows of data in each of the 6 workbooks. *I've got a 7th workbook with
7 worksheets. *The first 6 worksheets of this workbook are set up to
pull in the data from the other 6 workbooks. *How do I set up the 7th
worksheet to put all the data from the first 6 worksheets together in
a continuous list of rows - in no particular order but without
dividing the worksheet into 6 individual sections?