Create 10 similar tables with Excel VBA

Hi all.
This is my case:
1. I have a calculation Excel file with data for 10 partners.
1.1. I have Excel file with 4 tabs.
2. I need to change the partner number in one tab, in order to calculate the data in the other 3 tabs.
3. Then I need to export the three tabs with a new name (the one of the partners) in a new file.
4. This should be repeated for every partner.

In general, I can write a slow macro with macro recorder, which does exactly this. But the problem is, that I should later make this for 100 partners and it would last about 3-4 minutes pro partner to create, calculate, save and close their worksheets... And 400 minutes is about 4 times more than I would like to wait.
So, any practical ideas would be appreciated (I am aware how to stop & start calculations and animation, so you can skip these ones).

And have a nice day!

Hi
Actually the macro is really a long one... (with macro recorder and it can be optimized a lot...), but I do not have time || knowledge )

So, in general, I was thinking about a code, doing the following:

1. Copy 3 tabs to a new file.
2. Close the file.


Consider the names of the tabs as AA,BB,CC.
Consider the name of the new file as 1-123.

Any ideas?
Sorry for not sharing my macro, but it is useless(99% written with macro recorder) and probably some of my colleagues may say that it is confidential...

Actually, I have managed to do something on this request -

Please Login or Register  to view this content.

Now I am trying to save it as values... Any ideas? (also for improvement... for example how to make it with a loop and array, in stead of hard coding the tabs?)

Thank You!
The only thing I have added is:

- Spreadsheet calculation

Please Login or Register  to view this content.

A loop for more files to be generated and the standard:

Please Login or Register  to view this content.

Honestly, Greg M, you are GOOD!