Move customer data in separate workbooks

Hello,
I was wondering if anyone has a quick macro that will help me achieve my goal. I have the task of taking an excel spreadsheet of user entitlements and parsing the information into individual workbooks based on the column called "CustomerName", i.e. all lines that have "Customer ABC" will be in one workbook. The workbooks will need to be converted to .PDF and then sent out to customers to review. Other requirements include having "all borders" so that the information will be in a grid in .pdf, the headers need to remain on all workbooks, and all information from the rows that correspond to "CustomerName" have to be copied over as well. I have attached a sample of the excel spreadsheet and what the final product should look like. Thanks in advance and let me know if I can clairfy anything.

Works perfectly, thank you!!!!