I have an ivnentory workbook with several sheets. THe
main sheet has a list of six different categories and
there is a separate sheet for each category.

I would like the category sheets to auto-fill form the
main sheet in the book. Then if the status changes - from
for sale to sold, I would like the sheets to auto update
themselves.

Is this possible, and if so how in the world do I do it?

Thanks.