Need asset inventory excel where one master sheet and on summary page there are some optio

Need asset inventory excel where one master sheet and on summary page there are some option to generate report.


Option like

Department wise List, (Like Purchase, GP, IT sale)

Asset type wise list (like Laptop, desktop, server)

Year wise list (Like 2011, 2012, 2013)

Warranty (Warranty expire in the year)

Replacement (Replacement in year)

Also we need easy access to add new department and type if required in future.

Like I can add type in master sheet and that will display on summary page to generate report.

Let me know if you need any more details

Need help how i can create same as i am new user for micro and all .

It is also ok if any one have same format.