I do not really understand fully what you are tryng to do, but here ar
a couple of ideas.

1. Using Excel : If you can, it would be better to put everything int
a single table. We all tend to start the wrong way round by havin
numerous sheets and try to summarise them, when putting everything int
a single table (despite the need for additional columns, and th
seeming duplication of data) is much more efficient, enabling us t
use the more powerful functions of Excel & Pivot Tables. I call thi
the "Database approach".

2. Access : The way you describe your data as consisting of variou
"lookup tables" does lend itself to manipulation by MS Access. It seem
you have the makings of a Relational Database where Access is able t
automatically display columns of data in a form that appears to be
single table, but, in fact, consists of the contents of several. Thi
requires tables to be matchable with unique lookup values in bot
tables that Access can use to make the link.

You can set up a "Make Table Query" that does, in fact, put everythin
into a single table. This can then be linked to Excel for summarising
I do not recommend Access for this latter purpose. It is not so goo
when you need to depart from the tabular output

--
Message posted from http://www.ExcelForum.com