Split a Worksheet into multiple Worksheets based off the DATA-SUBTOTAL

Hi!
I'm brand new to this forum, but not so new with Excel, except when it comes to Macros and VBA. I run a report once a month that contains about 500 rows of data and I subtotal with the SUBTOTAL button under the DATA tab against a couple of columns. I have tried to split the main worksheet into multiple worksheets based on the subtotal, but when I have copied any code, it doesn't work well with the subtotal row for each unique value in the column. Is there any code, macro, or something else I can use to split this. My goal is to split it, and then save each individual worksheet as a separate PDF file. Right now, I am copying and pasting each group to a new workbook, and then saving that as a PDF. It's very tedious. If this is possible, is it also possible to have a special header for each individual worksheet. I have also attached a file with a master worksheet, and management worksheet. The master worksheet is before I subtotal my data in the management worksheet. Thank You!!Maintenance June 2013.xlsx

Yes, it would be on the Client Subtotal. Thank You!!

I use the first 11 rows or so of the spreadsheet for my address, phone, and a logo. I attached the file here what the header is for all the split worksheets. I don't know it that will help?

You would only be using the top 11 rows of the (Owner) Maintenance (Month) 2014 as header information for the other sheet. I can give you another file where now the columns match. Thanks!

I bring in all the information from Access. I then sort and filter, adjust and subtotal as needed in the Master workbook in Excel. Once I am done with that, I open up the Workbook with the header and copy and paste each set of rows from the master sheet to the one with the header. I then save it as a PDF as it becomes an invoice for each individual client. I usually have a couple hundred to copy and paste each month and it becomes tedious. If I can separate the Master sheet into individual sheets within the same workbook with some sort of code that would bring in the "header" rows, I can easliy save each sheet as a PDF.

Yes. The most recent upload and the second upload have the exact same columns. The second one just has the "header" information if that is even possible. Thanks!!

If you can do that, that would be awesome!!