Tom,
Thank you for helping me out. What I am trying to accomplish is to use the
userform (Change_Region) to choose from one or more regions from the 5
regions list below (found in ListBox1). If I choose two or more regions,
such as Northeast, Midwest, and Southeast, I need the following to happen:

When I click a button, the data from the Northeast worksheet would be pasted
into the Master worksheet, starting in the second row. Then the data from
the Midwest worksheet would be pasted below the Northeast data in the
"Master" worksheet, and then the data from the Southeast worksheet would be
pasted below the Midwest data in the Master worksheet.

<Regions
Northeast
Southeast
Midwest
Southwest
West

The number 4 in the VLOOKUP was meant to pull in the names of the named
ranges so that I could select the data that needs to be copied. I was using
VLOOKUP because I was hoping to use the order the regions are in ListBox1 to
access the named range of each region.

Any help you can provide would be appreciated.