Excel Report/Dashboard to take input of 4-character customer code and output a protected dashboard for each customer.

I need someone to configure a customer-facing Summary Sheet for me. (Basically this is an MSP summary sheet for each client regarding the health, performance, windows-updates, etc. of their computer fleet for the last month.) I need a macro which can go through a list of 4-Character customer codes, filter the data to that customer, and present Charts and Tables of relevant information (from each of the 9 data sheets I have in the same workbook). Each data sheet has the 4-character customer-specific identifier in each data row. I would like the output to be either a locked Excel showing only the Summary Page (an Excel file saved per customer) or saved in PDF per client. This will have our logo, and will display the relevant info from each sheet to the customer in an easy-to-read format. 9 Worksheets have been imported from a database into the 'master' workbook. Each sheet arrives named, and data is in a named Table on each sheet. Data on these sheets shows information on around 3000 PC's. e.g. one sheet called FixedDriveSpace shows any PC with less than 10% of hard drive space remaining on fixed drives, another shows windows updates completed, another shows windows updates failed, etc. I will provide a list of criteria for each data sheet. e.g. The Windows Updates section will show a pie-chart of Updates Completed, Failed and Pending - and a table listing those PC's with Failed Patches; with date it failed, name of the patch, etc. e.g. The FixedDriveSpaceLessThan10% section will show just a table; with PC name, percentage free, and logon user. (The logon user comes from a different sheet - so that is an extra consideration.) Looking to get all this as VBA, so I can add-modify other datasets at a later time. (I would try this myself, but I don't have the necessary time to do so. I am aiming to take a shortcut with Freelancer.)