Hi Albie

You can start here
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Albie" wrote in message ...
I have a series of worksheets (about 180) that contain a form with vaious
data on the form. Each worksheet has the data in the exact location. I
would like to "merge" these records on to one worksheet in table format. The
worksheet names are all of the same format "mmddyy 1st" or "mmddyy 2nd" to
distiquish between 1st and 2nd shift of each day. I am very new to VBA
programming in Excel and need the basics as well. Thanks