Is it possible to have a dynamic pivot table that looks into multiple sources that are formatted the same way (same headings).

I am trying to compare data in multiple worksheets across about four workbooks. Please comment if you have some ideas on how to do this. A micro will be ideal.

Thanks!