Hi All,
I'm trying to use a macro to create lists out of the columns in multiple
worksheets. The worksheets will have specific names but they could vary as
well as the column header names. Example:

Sheet 1 (Named Roster by Building)

Columns Bldg# Room# Occupant
123 321 Smith, Joe
123 432 Doe, Jane
Sheet 2 would have a different name and column headings but I want it to do
the same thing; create lists from all the columns so I can sort from any one
of the rows or multiple rows as needed. I want it to do this for all the
sheets in the file at one time. Also I don't need the data moved to another
sheet, I want it to create the lists just as if I had selected the columns
and gone to DataListCreate List. Thoughts? Thanks for any and all help.