I forgot one major detail: On the worksheets there might be multiple
entries, that when copied should get some universal entries on the form
(date, shift, etc). Not all of the worksheets have the same number of
entries...

"Albie" wrote:

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