Thanks for your response Dave...

I forgot to mention one detail though. Every year, the source data
will be updated. My objective is to design my spreadsheets so that I
can just replace the source file and all the regional data is
automatically updated. The linking is the easy part, its just
extracting the information that is difficult for me.

I replied while glazing over some of the references you gave me. So, I
haven't looked at everything yet.

I just thought I'd mention this just in case you had other references
to give me. Thanks.


--
Chris435435
------------------------------------------------------------------------
Chris435435's Profile: http://www.excelforum.com/member.php...o&userid=35906
View this thread: http://www.excelforum.com/showthread...hreadid=556969