Lets say that I have an Excel workbook which contains 10 sheets; the first sheet is named Activities and s kind of an entry form and the rest are named lets say Design, Materials, Purchasing, etc.

What I want to do is when I write an entry on the Activities sheet which contains the word Design at the beginning, this entry is also copied to the Design sheet. Therefore when I want to find something pertaining to Design I just click the Design sheet

I have this formula in my budget worksheet =IF(LEFT(B345,3)="GAS",IF(D345="",-C345,-D345),"") which I made perhaps 15 years ago but since I retire I have forgotten a lot about Excel. I guess it should be a similar formula but instead of writing the value to the Gas column it writes the value to the Design sheet

Is it possible to achieve what I want?