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!