pivot table - multiple excel sources

[David]

Hi

I'd like to join data from several excel sheets, ideally from different
workbooks

The SQL UNION ALL statement works OK to combine data for sheets from a
single workbook but is there a way to combine data from different workbooks
into a single
recordset and then associate a pivot table with this single recordset ?

thanks