Is it possible to save one sheet tht is contained within a workbook of 50+
sheets? Since I have to attach the saved sheet to a record in another
application it will save almost 2MB of space.

If, however, I have to re-open the newly saved workbook to make changes I
will need it to be "re-inserted" into the master workbook in order for the
multiple lookups to work.

I have tried to use 2 workbooks to facilitate the lookups and that is
working - until I have to reload a saved workbook, because it has a name that
is not recognized by the lookup workbook.

I do not like links (maybe because I am not as familiar with them as I
should be) and would like to have a way for the lookup workbook to
automatically recognize the main workbook - regardless of its name.