I have workbooks set up in excel 2010 for each month of the year that tracks all the movements of our haulage company. Within each workbook there is a sheet for every week along with sheets with varying information on them that the weekly sheets link to. For every month I want to be able to summarise the different types of jobs we do and copy the lines relating to these to a new workbook. For example, in each weekly sheet column D contains my job codes, I would like all of the codes beginning with "bc" to be copied to a new workbook so that I end up with a workbook called "bc loads" that contains a sheet for every month of the year detailing all of the lines relating to those codes for each of those months. Hope that makes sense. I want to be able to apply this to various columns in my weekly sheets but hopefully if I get the macros for one then I can amend it to suit.

Thanks