Can you be more specific? Are the 50 workbooks closed? What line does
the code fail on? I ran it with four workbooks and it worked, so I'm
confused. Can you try it with just a few workbooks, or are you trying
it with all 50 workbooks each time?

--JP

On Oct 7, 2:00*pm, Mrs. Robinson
wrote:
I'm not having any luck with any of these solutions. *I"m going to keep
plugging away at it. *Thanks for all the suggestions!



"JP" wrote:
I put four one-sheet workbooks on my desktop, then created a new
workbook and ran the following macro (basically an amalgam of the
edits Luke and John already posted). I selected the four (closed)
workbooks, and it copied the sheets from each workbook into the
current workbook.