hi everyone, i need some help with a macro, not sure where to start:

I am trying to write a macro which will pull data from different sheets
in an excel file, if i chose that sheet to be selected (via a 1 or 0)
and copy that data and paste the data into a new sheet.

all data is in columns A & B of each sheet and runs to row 100.
Basically, if the sheet is selected with a 1, then i'd want the macro
to go to that sheet, copy the range: A1:B100, and then paste is to a
new sheet. I would want the results (of only the selected sheets) to
end up in columns A & B of the summary sheet...basically creating one
long set of data of only the sheets I selected via a 1 or 0 on the
summary sheet...

does that make sense?