Can Excel do this? And if so, how?

I have a workbook with 6 or 7 sheets broken down by expense type for an RV i.e.  Fuel, Lodging, Equipment, Maintenance, etc.   On each sheet I have several columns... Date, Location, Cost, Descript...