Multiple Crosstab Creation Help

[Badswell]

I have a blank database that has been designed to be used as an analysis application of companies. The user imports information from Excel into specific tables that feed into a series of queries. One of the queries is a multiple crosstab query that is fed information from 9 crosstab queries. The problem I have run into now is this. I have set up the multiple crosstab using specific columns (not the * selection) in order to control the order and grouping in which the results are displayed. If the database is blank or a new company's profile and information is entered, the multiple crosstab table is limited to the static fields that it was orginally built on from the 9 crosstab queries. When the application is used, the records the crosstabs were built on will have been deleted.

Now, the multiple crosstab query does not recognize any of the new company information because it was built on the specific records of the data that I currently have in it. Is there any way to have the multiple crosstab query pull the fields in from each of the 9 crosstab queries based on whatever company information has is currently loaded (whether it is an existing record or a recently added one) and also control the order & grouping of the query result?

I know this can be easily done by going & re-adding each crosstab fields per company, but the point of the database is to create reports that users will not have to do any backend work to use.