Automatically create subsheets based on master sheet category type

Hi,

I am new to the forum and hope I am posting this in the correct forum. I have searched through several sites and threads that seemed similar to what I am looking for but they aren't quite what I am looking for. Any help is greatly appreciated!

I am creating a master equipment list for the company I work at. I would like to have one master sheet that gets updated each time new equipment is purchased. From there, worksheets are created based on the category of the item purchased. I would like to be able to update information, add, remove equipment (ie, if it breaks or is sold) and have that information automatically update in the subsheets.

For example, the master sheet would have the following categories of equipment:

Hard Drives
Software
Monitors
Computers
Speakers

From there, I'd like to have individual sheets for each of the above categories with all of information in the items row added those individual sheets.

I've attached an example of what I'd like my excel sheet to look like.

From my searching I'm starting to get confused with what I should use to accomplish this (VLookup, Pivot table, Macros, Visual Basic, etc). I tried advanced filtering but that doesn't seem to automatically update as changes are made to the master equipment sheet.

Thanks for any help you can provide!
Adam