I have a need to dump data into a main worksheet and have multiple
supplementary worksheets populate their data based on the value in column A.
Example: Master sheet has data in columns A-F and is sorted by Customer Class
in column A. There are 19 rows of data that have class '06' in column A, and
I create a separate worksheet titled '06' that I wish to have populated with
all the data for class '06' customers via a formula of some kind. A formula
of some sort is preferred over VB script. The purpose of this is to
periodically update the data in the master sheet so it flows down to the
split sheets and populate the charts which I have already set up. Thanks!