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?