Chris wrote:

is there any way that i could have all my other worksheets import defined
name ranges from a source worksheet? and having them update every time i open
them or change the ranges in the source?
appreciated. i'm starting to get tired and frustrated.... thanks.

I'm not sure what your problem is exactly, but have you tried using
data - import external data - new database query - databases - excel
files, instead of just linking to files?