Ok Firstly, when i add in a new row of information onto the "Data" tab i want to to update automatically in the next relevant tab as derived by the type of activity it is. This is currently not working for me now, but it did in the past.

The second issue is when i use a column to arrange the information on the "Data" tab, for example arranging it by amount or by date or by customer, it changes the information in the other tabs. I would have thought this shouldn't happen as the information is still derived by the type of activity.

When you say "Your naming of d and Activity is wrong. Those names span rows 3:211. It should be 2:210." i cant figure out how to change it back, can you see where i am going wrong.

Ideally when i sum the column D in the "Data" tab, it should equal the sum of "C11 +C21+C30" ONTHE "OVER VIEW" TAB. I cant figure out why this is happening!!