Combining and Filtering Worksheets

Hi,
Is there a way of combining multiple worksheets into one? I'm ultimately trying to combine a bunch of tables I exported from a PDF into excel all into one worksheet, then filter them all only showing students who are 'enrolled'. Then I want to matchup the list of names in the worksheet to a spreadsheet containing all the email addresses in this organization. Then I want to create a mail merge emailing anyone who is enrolled.



Thanks,
Al

Maybe this will help. I'm trying to export a PDF into a foirmat I can put into a database and use for a mail merge. So far the best export I was able to get looks like this:

---------------------Page 1---------------------

Class Sessions Detail Report

Course Number: CRS0001290 Trainer: Location:
Course Version: 1 Begin: 1/1/2017 12:59 PM Capacity: 250
Document Version: End: 1/1/2017 12:59 PM Total Enrolled: 225

lastname, 1st name PSN0001004 Academy Enrolled

lastname, 1st name PSN0001005 Academy Enrolled

lastname, 1st name PSN0001253 Academy Enrolled

lastname, 1st name PSN0001007 Academy Completed

lastname, 1st name PSN0001008 Academy Completed

lastname, 1st name PSN0001009 Support Completed

lastname, 1st name PSN0001010 Academy Enrolled

lastname, 1st name PSN0001449 Medical Enrolled

lastname, 1st name PSN0001495 Academy Completed

lastname, 1st name PSN0001494 Maintenance Enrolled

lastname, 1st name PSN0001218 Programs & Treatment Completed

lastname, 1st name PSN0001245 Medical Enrolled

lastname, 1st name PSN0001013 Academy Completed

lastname, 1st name PSN0001014 Academy Completed

lastname, 1st name PSN0001513 Individual Completed

lastname, 1st name PSN0001016 Academy Completed

lastname, 1st name PSN0001017 Academy Enrolled

lastname, 1st name PSN0001018 Academy Completed

lastname, 1st name PSN0001445 Medical Enrolled

Page 1/83 Wednesday, April 26, 2017
---------------------Page 2---------------------

Class Sessions Detail Report

Course Number: CRS0001290 Trainer: Location:
Course Version: 1 Begin: 1/1/2017 12:59 PM Capacity: 250
Document Version: End: 1/1/2017 12:59 PM Total Enrolled: 225


After the 'total enrolled' section on the last line is another list of trainees. This repeats over and over. To make this work in excel I have to get all the columns in, and make a new column that lists the course number associated with each trainee. The Begin and end date have to get their own column as well.
How would you go about getting this export into excel along with the columns containing the info in the headers?

Thanks,
Al