SET WSD3 = to workbook just opened

[Jeep56]

I have written a macro which creates 4 pivot tables on 4 different worksheets. These sheets are in the same workbook as the macro so, I would like to change my code.
I've created 4 different workbooks for each of my pivotables. I want to open a workbook "SET" a name to the workbook just opened to say WSD3
Then, I can change the "destination" of my pivot table. I will need to add a worksheet in each workbook and name it based on the month in "A2" of my data sheet.
i.e workbook "A" sheets sep,oct,nov....Aug workbook"B" Basically, I'm not sure how to modify the second set of code with the first set of code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Jeep56]

I've revised my code as follows but it's still not working. The file is not opening and I'm not sure how to name the worksheet based on whats in cell A2 of my data worksheets. I think this is fairly basic but I'm just not getting it.

Please Login or Register  to view this content.

all help is appreciated

[Andy Pope]

Not sure if I have the right filename and worksheet name but you should get the idea of setting object refereneces.

Please Login or Register  to view this content.