I was able to use the ALT F11 and see where to put the code, so that was a
big help. I read through your examples, but since I don't know much about
advanced commands in Macros, SQL or VBA, I have no idea what some of this
does.

It looks like I should use the part that says "Copy from Row 2 till the last
row with data", since they will be continually filling in the individual
worksheets. Where it says "ThisWorkbook.Worksheets ("MergeSheet")" should I
be replacing that with names of all the tabs, or does the program just know
because the code is in that workbook? Does the data in each tab need to have
a range name first? Do I have to also include "Common Functions required for
all routines" to make this work?

Thank you for your help!


"Ron de Bruin" wrote:

See my site for a few examples
For example this one
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"PolQueen" wrote in message ...
Using Excel 2003 - We have worksheets with tabs called 'Sec 10', 'Sec 11',
etc. (up to Sec 61) that are updated by the individuals that work in those
sections. We would like to link all of those worksheets into a master that
will show all data in each section consolidated into one (with MANY rows!),
and that will continually update the master as data is entered in each
worksheet. All worksheets have the same column headers in Row 1 (NHBD, SEC,
BLK, LOT, DATE, WHO, STATUS, NOTES). We would also like to keep the Master
sorted by SEC then BLK, then LOT order.

I don't know VBA or any advanced formulas, and have tried using
consolidation, normal linking (which produces a number, not the individual
rows of data). The people using this don't know how to use or have Access,
so I need to figure out a simple way to do this in Excel. THANK YOU!