Naming sheets using names from an input table

[agamzine]

Hi everyone,

First ever post!

I am modelling several companies in one workbook. Each company has an input sheet, calc sheet and results sheet. I would like the model to be dynamic, so in an 'Assumptions' sheet I can have a table with the company names in it. These names should be an input, so the user changes them and then hits a macro button which then goes and updates the names of the other sheets to:

Company A - Input
Company A - Calc
Company A - Results
Company B - Input
Company B - Calc
Company B - Results
Company C - Input
...

And so on.

Any help appreciated.

Thanks!