Replicate range names in multiple sheets

It might be possible with some combination of the Indirect, Mid, and Cell functions. For example, this formula will sum A1:B1 on any given sheet: =SUM(INDIRECT("'"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)&"'!"&"A1:B1"))

I would assume your formulas are more complex, but you can replace "A1:B1" with "A1:B"&Index(B:B,Match(99^99,B:B)) to get to the last value in B (and so handle variable ranges) or other such manipulations. Hope this helps. If you're still stuck, please post back with an example of the folder or the formulas you're working with. Note that you will only have to create one named range that should work with any sheet.