You Could have something like this in cell A7 in each worksheet

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,30)

regards

Paul


DannyS wrote:
Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!