New sheet based on template to auto populate column in summary page

Good Morning All!

I'd usually be able to do this simply with macro's but the boss doesn't want me to use them and I'm pretty rubbish with formula's. So any help would be awesome.

just a few wee questions.

1. I have a template page which will be copied and populated for each project. In cell C1 is the project name - Can I use this information to automatically re-name the sheet? So when I populate it the sheet name will change to whatever the project name is.

2. On the summary sheet, from column F onwards would contain a range of data from each projects sheet. So F1 would be the sheet name then F3:F14 is a copy of Project sheet range J11:J22

My boss would like it so any time you add a sheet, it would create a new column with the ranges already linked. As I said I'm not the best with formula's. I could do it all manually but if theres any way to get excel to do it without using macro's then that would be fab.

workbook attached.

Thanks in advance

R

Any ideas if this is even possible?

Sorry to keep posting guys but the boss is on my shoulders to try get this done today!