I'm needing to copy rows of raw data(contained in Workbook 1) into specific worksheets(in Workbook 2), based on Application/Program. There is a field within the raw data that indicates which worksheet in Workbook 2 it needs to be copied to(there is a separate worksheet for each Program, and a Program field within the raw dataset), and I would like to automate the copying of this raw data out to the appropriate worksheets.

Can anyone help?