I would think probably copy and paste from book 1 to the end of records on
book 2, then repeat to book 3, til all on one sheet in one book.

Then, you can either do a pivot table or just import the data into an Access
Database and run a query that groups by all values...

"rwaldsmith" wrote:

I lhave 6 workbooks all the same column labels that contain from 100 to 30
records of various clients. There are a number of duplicates due to
inexperience of entering data and managing files. I have all of in one file
folder and have made each on a "shared" file. I get an error message when
trying to merge the sheets in order to remove duplicates. What is the way
out of this mess?