Want to automate mutliple copies of a worksheet and titles of each sheet

Hi everyone,

I'm looking to automate the process of repeating an excel worksheet (which is set up with various tables and formulas) for various countries.

I have a referenced list of countries set up in worksheet 1. So for example: in worksheet 2 I have a sheet set up for Albania - and I want to repeat this for another 100 countries. . Can I use the reference list of countries to auto-repeat worksheet 2 for worksheets 3 - 102 and auto-title the worksheet tabs? (E.g. Brazil, Canada, Chile..............)

Really appreciate your help.

Greg

Thanks for the response Mike - I've managed to sort a solution fortunately. Appreciate it though.

Greg