Move TAB to another Worksheet & Replace

[aiwnjoo]

Hi, I don't think its possible but worth asking.

I have one sheet named;

(Restored)Consultant1Test.xls

I want to move Sheet1 from here to Consultant1Test.xls and replace its current Sheet1.

I need to do this for 150 consultants, any way to sort of have a macro to do this but the macro work globally for all consultants? It would take ages to do the task but would quicker than manually doing it.

Thanks.

 

[Jerry Sullivan]

Hi, Could you clarify the details a bit more?

1. Where are the 150 Consultants coming from? (do you have a separate xls file already for each, a separate sheet for each or a list of 150 names on an existing sheet).

2. Did you mean to write one workbook instead of one sheet below?

I have one sheet named;

(Restored)Consultant1Test.xls

3. Any more details you can provide about what you have currently will help.