Your life will be a lot easier if you just use
datafilterautofilterfilter on categorywork with the data

However, if they INSIST, use a macro to do the same thing for each category
and copy to the tabs. Or even a worksheet_change event that would
automatically copy and append the relevant data with each entry.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joe" wrote in message
...
I am looking for a function that will break up a spreadsheet into separate
tabs, using a field. I dont know how much time I have wasted when
management
wants "all category A in one tab, all category B in the next tab, and so
on
thru category Z." It is all the same spreadsheet, with each category in a
separate tabbed sheet. So I spend hours cutting and pasting. Then, there
is
some small change in the input data spreadsheet, so I have to start all
over
again.