I have several spreadsheets that get disdributed to a large number of
end users (expense sheets and department budget spreadsheets). I need
a way, hopefully within excel, to consolidate some of the data from all
of the separate files into a consolidated view and compare the results
from period to period.

Does anyone know of an easy way to do this?

Thanks in advance,
Dave