help with vba

[Jane Doe]

I have a situation where one excel file contains 10,000 and I need to
compile a summary list similar to this SQL statement:
Select Vendor, Month(po_date), sum(po_amt) as po_amt
Where isb='YES'
Group By Vendor, Month(po_date)

result will look like this:
VENDOR JAN FEB MAR APR etc..
A 10000 10000 50000
B 33456 23242 239385
C 21243 95840 843040
etc..


Is it possible to:
1) create a pivot table using VBA,
2) and if the 10,000 records get updated, the pivot table will auto refresh

The result of the above pivot table will be referenced on another excel
file.

Pls help. TIA~