First of all, forgive me if this has been covered before. But I can't seem
to find a doable solution for me. Here's my problem:

I have a form that uses VLOOKUP to access data another sheet in the same
workbook. The problem is that the whole workbook is almost 11mb!!
I want to be able to make the user-input part be separate from all of my
data sources, thereby freeing valuable resources (i.e., I need to have 1 form
accessing 3-4 external sources).
Any help out there?
Thanks in advance.
Chris.