Hi
the solution would be VBA. You may check:
http://www.rondebruin.nl/copy3.htm

"RC" wrote:

I have approx 100 workbooks. All contain the standard 3 worksheets but only
the first worksheet has the data I require (other two sheets are empty). Each
worksheet is of the same format. i.e. column headings are the same. There are
7 columns of data in each worksheet/workbook.
The data always starts at cell A13 (cells/rows above are just headings and
unwanted information)

I want to find a simple way to combine the data into one master
workbook/worksheet without me having to open each one and cut n paste the
data manually to one worksheet.

I do not understand visual basic so if thats the answer I'm stuffed - but
otherwise - is there a simple solution.

Thanks

Ron