i am dealing with 30000 line items of data. i would like to populate various
worksheets based on updated data on the "DATA" sheet. Example: Data sheet
has data for 30 different product lines. i would like to select product A
and any related data to product A and move it on a new worksheet, named "A".
Currently i use the filter, cut and paste feature to do this but would like
to know of a faster method.

thanks