Hi,

I think this is what the Pivot Table does for you!!! You will need to expand the range of what data is the source for the PT and Refresh the table after putting in more data, but this is what it does. You enter data on Sheet1 and the Pivot Table will show it after doing a refresh Pivit Table Data.

Play with my example a while and I think you will see.