Peo Sjoblom wrote...
Sheets are absolute, I would personally just do a search and replace
and
replace the sheet names. Here's a link to a UDF by John Walkenbach

http://www.j-walk.com/ss/excel/tips/tip63.htm

Walkenbach's SHEETOFFSET is a crippled udf. Unlike Excel's own OFFSET
function, SHEETOFFSET doesn't return range objects.

As an alternative,

http://groups-beta.google.com/group/...0f6e91b058ac38