Wow Ron, thank you very much for the great help.

The .PasteSpecial, like AutoFilter, is entirely new to me.

If I understand the code correctly, we are actually creating a new
workbook and putting the record returned from the list box into the
workbook.

What I actually need to do is read the record to identify which wss off
the master price sheet I need to add to the new workbook by comparing
the ws.name on the record to the ws.name in the master wb and then
copy/pastespecial those I need to the new wb.
Then I need to look at the worksheets in the new wb, identify the
columns that I need to show on each of these ws (will always be colA,
colB and colC plus 1 more column per ws), hide the rest of the columns,
and finally show the new wb to the user.

Your help in teaching me how to isolate the record that I need is a
major hurdle to have solved towards this app (and useful for most future
apps too I am sure). Now I need to learn how to read the record to pass
the ws names I need to a function? that will do the copy/paste job. Then
another function to read the record again to see what cols from each ws
in the new wb need to be hidden from view.

I'm thinking something like this might work (though I am really just
stumbling around trying to find my way here) to add the ws to the new
wb:

For each ws.name on record
       if ws.name on record then
               copy (or .PasteSpecial?) ws.name from master to new wb
       end if
next
This needs to compare the record fields to the master wb wss.name
somehow

Then to hide the cols I don't want showing
For each ws.name in new wb
       For each colAddr on record
               if coladdr not on record then
                       hide.coladdr
               end if
       next
next
I'm sure my syntax needs work here but for now I am just trying to think
out the jobs that need to be accomplished.

I have to go thru many file folders to get the ws.names and coladdrs for
each of the customers' records, so I have time to keep pondering these
problems, keep reading the groups, and learn and test as much as I can.

Your help goes a long way in making this feasible for me to finish
Thank you.
Could you recommend a book or helper site to study that doesn't contain
888 bazillion pages? Just a good index and some good examples would be
great and something my schedule could handle.
TIA
Joanne