Hi there.. My knowledge of excel is minimal, but I know the basics of it.

here's the problem i have

I have a primary worksheet that has the following column headers
state | county | ID# | name | price | date

i would like to do the following:

create two separate worksheets (which is pretty much a replicate or the primary one) and when I update the primary worksheet (add new data, etc) it will also reflect the changes for the other worksheets. next, it would group by the state and also reflect the subtotal of the price (grouping).
  1. worksheet #1 - primary
  2. worksheet #2 - replicate of primary but filters by county and price
  3. worksheet #3 - replicate of primary but filters by state and price

i have looked at two things already:
1) pivot tables (refresh/update option) but does not work well when i create reports
2) paste link special works only with the current data set i have.. if i add a new record to it, the other two worksheets do not update accordingly.

Is there code involved to get this to work?

Thanks in advance!