I have some code that creates a new sheet and I wish to enter the
formula below, in cell A22 on a sheet called "summary", slight twist
to this is that I wish to have the flexibility to create more sheets
and these would be named 'Emply # 14'; 'Emply # 15' etc etc. I would
have a similar formula to below, except in cells A23; A24 etc etc. Can
this be done?

=PROPER(MID(CELL("filename",'Emply # 13'!A
$1),FIND("]",CELL("filename",'Emply # 13'!A$1))+1,32))

Thanks