John, et al;

Sorry, I didn't think about the sheet names when I made the file
available for download.

Sheet1 in my file would be 'Printable Report'. The certifications are
entered into A9:A24 on that sheet. They are referred to on the
subsequent four sheets in cells D1:K1.

For arguments sake, lets say "EMT" is in Sheets(Printable Report)"A9"
and there is one entry on each of the subsequent pages (Classroom, CBT,
Journals & Magazines, Other Training) that is applicable to the EMT
certification (indicated by a checked box and relative TRUE value in
the underlying cell).

I want the user to be able to select "EMT" (the value of A9) from a
combobox in a userform (I know how to do that) and then have a routine
that would select all the rows on the subsequent sheets that have a
TRUE value in that column (would be column D in our example) and copy
them to another worksheet (will be 'Individual Summary')

In short, the routine would need to find the matching rows and copy
them into the next available empty row of the output sheet.

Does that help?

Thanks again,

John Bundy wrote:
I have your sheet but can't figure out what your asking. What data do you
need and on what sheet do you need it? What sheet are you considering Sheet1?