Excel 2010: How show relevant data on right tab

Hi,

I am new to Excel 2010 and have a question I suppose is something right out of the basic course.

I am setting up a sheet that so far has five columns and seven tabs. The column headings are: Date, Supplier, Price incl tax, Price excl tax and Comment (plz see linked image).

The tabs are: Overview, Investments 2009, Investments 2010 etc and Maintenance 2009, Maintenance 2010 etc, seven in all.

The raw data are supplier invoices and the items purchased for the property fall in either the investments- or the maintenance categories for each year and should be shown thus when viewing that tab.

So, clicking the Investments 2009 tab should reveal the furnace bought June 6 2009, and the Maintenance 2010 tab should show fuel bought for the furnace that year.

I am thankful for any advice!

Edited June 19, 201113 yr by Sinsemilla