Sheet Reference in Formula
 

Hi

I WILL have 100 worksheets in my workbook. they are labeled Trip(1),
Trip(2), etc.
I need to be able to make a copy of Trip(2) which will be called Triup(3)
(and so on). I am successful at having it auto name my worksheets - but i
have a formula in the sheet which is ='TRIP(1)'!E39:F39

When I copy the sheet it is not updating the sheet reference. so when I
copy trip(2) to Trip(3) i want the formula to copy and update to read
='TRIP(2)'!E39:F39

Any Suggestions? thanks