Alastair-

Yes, you described the process that I have in place now. I just copied LC and DC into the House.xlsx file to show you what I am doing. It works for me, but it has its drawbacks as if you mistype the new worksheet name the link will be broken. I'm trying to make it more robust as I will be sharing this excel file structure with other people in my organization.

Tom