Combining data from 6 workbooks into one master

[natty2506]

Please can you help with this.

I have 6 workbooks with one sheet in each that is identical - with text data
in

I need to design a 'master' sheet that when one is updated so is the master.

The amount of rows will differ for each sheet but the column names are the
same in the same place.

Thanks is advance

 

[Luke M]

Check out Ron's site, especially the section about halfway down dealing with
Copy/Paste/Merge.
http://www.rondebruin.nl/tips.htm

He has several ways of combining multiple sheets and/or workbooks into a a
summary workbook/worksheet/csv file.