I have a workbook which contains an inventory of computers, and it works
well in a single worksheet - not very complicated. I'd like to have a 2nd
and 3rd worksheet within the same workbook which show a subset of rows from
the 1st worksheet, and are automatically kept in sync with changes to the
1st worksheet.

For instance, the inventory shows the user of each computer, but in some
cases that is 'Unknown' - I'd like all rows with an 'Unknown' owner to
appear in the 2nd worksheet. I also track computer make & model, and would
like all rows with a 'Dell' computer make to appear in the 3rd worksheet.
This type of functionality is easy in Access, using queries against a table.

Can this be done in Excel 2003?

Thanks much in advance.