How can I use one Query to get different results in the same Workbook??

Hello Experts,

I would like to show about 10 company codes in Workbook beside each others. All company Codes are maintained in the query, but I need to create one table for each company code, for example table one to show company code A600, table two beside table one to show company code A601 an so on..all these tables should show the query results, how could I restrict that in the workbook??? Definitely, i can not restrict that in the query, I need only to restrict the results of each table on a specific company code in order to compare between them .....all that should go with only one refresh to refresh the results of all table for the company codes????

is that clear??

Thanks,

Sherif