hi,

I have many workbooks which have 8-9 sheets each. All identical as an
e.g each work book represents a company and each sheet has some
financial data for that company.

I am adding a new sheet which has charts and formulas which refrence
other sheets in the same workbook.

I want to replicate this sheet in all other workbooks but the formulas
and charts need to refrence the sheets in the local workbook. But when
I copy and paste all the data is refrenced from the original sheet and
I have to fix every data point and this is very cumbersome and
ineffcieint. Is there some way to do this easily ?

thanks,

Arun