From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla