Thanks for the responses and sorry for the confusion. I was trying
to be brief, I know everyone is busy.

I have a workbook  that gathers summary data  to start a process (not a
user form, but a business form). This data is in three parts, a
general header (common to all), data in a row specific to a single
product and a grid listing further detail down a column.

This data is used to populate a second workbook (another business
form). The first workbook can contain data to populate up to 15 of
the second.

So, I am pulling  data from workbook one, opening workbook two and
adding it, moving back to workbook 1 and going to the next data set
and repeating.

I was able to solve my issue using the Workbooks(VARIABLE).Activate
code. May not be the most efficient way to process, but it seems to
be working.

Thanks all for the help, and again, sorry for the confusion.