Thanks to Bernie, I was able to build a macro to consolidate data
submitted by my stores. Currently, the macro opens approx 30
workbooks (one at a time), copies the specified data, and pastes it
into the proper column in the summary workbook. It's really going to
be a time-saver....

The next step .... sometimes, a store re-submits their data after the
consolidation has been completed. Instead of having to run the whole
consolidation again, I'd like to be able to specify which files need
to be updated.

So, here's my idea -- the current macro utilizes a 'hard-coded' array
to determine which files to open. I'd like to use checkboxes to
identify them instead. I'd have a list of the stores with a checkbox
next to each, plus an extra checkbox to 'update all'.

I know how to make the checkboxes and name them, but this is where I
get lost -- how do I build a macro to capture the names of checked
boxes and put them into an array? And how would I code the macro to
see the 'update all' box and know what to do?

TIA,
ray