Renaming multiple tabs from a list in sheet 1

Hi

Please could you help me with the following.
I would like to rename each tab with the list of names in sheet 1.
For Example, In sheet 1, I have the following list, Trade 1, Trade 2...Trade 5 ranging from cell A1:A5.
I would like to have each tab after Sheet 1 to be renamed as per the list in sheet 1.
The number of trades may vary from time to time, for instance 5, 10, 15 trades and would like the coding to cater for this.

Is this a possibility in VBA coding?

Thank you for reading my thread.

2Quick2Fast

How's this for you?

Please Login or Register  to view this content.

Hi Andrew-R

Thank you very much for this. This works perfectly.
One more question, I might want to add more sheets after sheet 1, that would I would not like to be benamed.
How would you adjust the code to only rename from sheet 3 onwards, leaving sheet 1 & 2 unchanged.

Thanks