I have to SQL Server views being drawn to 2 seperate worksheets as pivot tables in an excel 2007 file.

the results on worksheet1 include example data:

- company_name, tickets, month, year
company1, 3, 1,2009 
company2, 4, 1,2009 
company3, 5, 1,2009 
company3, 2, 2,2009 

results from worksheet2 include example data:

company_name, month, year , fee 
company1,      1   ,  2009   ,  2.00 
company2,      1   ,  2009   ,  3.00 
company3,      1   ,  2009   ,  4.00 
company3,      2   ,  2009   ,  2.00 

I would like the results of one worksheet to be reflected onto the pivot table of another with their corresponding companies.

for example in this case:

- company_name, tickets, month, year, fee 
company1, 3, 1,2009 , 2
company2, 4, 1,2009 , 3
company3, 5, 1,2009 , 4
company3, 2, 2,2009 , 2 

Is there a way to do this without vba?

thanks in advance