Excel VBA Work - Filter Pivot, Copy, Paste, save as new File

I need help to write a macro which will: - Filter 3 seperate pivots with different data sources based on the same filter criteria (i.e. all have same supplier number) - Copy the pivots and other defined cell data - Open the blank workbook template - Paste in the data from the 3 pivots as well as other additional cell data - save the template with a new name using the supplier name - Repeat and use the next supplier. Ultimately the macro will create a new workbook for each supplier based on a template and fill it with data from a master data source. Note that this is for dummy data, and i will take the macro and use it for the real data so please add comments in the macro which can help me understand what's going on. e.g. "This is saving the file in this file location"