VBA Sheets Order

Hi, I wonder whether someone may be able to help me please.

I'm using the code below to add multiple sheets to a workbook:

Please Login or Register  to view this content.

The code works, but the issue I have is that the position of the sheets when the workbook has been built, doesn't reflect the order by which I've listed them in the code i.e. the "BAS Consultants" sheet becomes the last sheet in the workbook rather than the first.

Could someone possibly tell me please, is there a way to force the sheets to be created in the position by which they are set in the list above.

Many thanks and kind regards

Chris

Hi @patel45, thank you for taking the time to reply to my post and for the help.

The solution works great.

Many thanks and kind regards

Chris

Hi @jolivanes, thank you very much for taking the time to reply to my post and for the suggestion, it is much appreciated.

Kind Regards

Chris