Enter data first sheet and it appears in another sheet

I don't know if this post is in the right forum. So right now I am doing a maintenance/cost plan for my thesis project.

My idea is that the first sheet will have the following;
- Total cost at the moment
- Total maintenance cost at the moment
- Total used hours for the forklift
But also
- Putting data that connects to another sheet that collects all the information so for an example
I am putting in the information
Name: Iggy
Cost: 200

And it will do two things, first, it will update the total cost at the moment and the information will be collected in the second sheet as a chart. This data will I do in the first sheet. I hope this is understandable

Welcome to the forum.

It is, however to clarify, I assume you mean that Iggy and 200 will be STORED somewhere once entered? If so, you probably need a user form for data entry, and this will require VBA. Shall I move the thread for you? Is your Excel version for Mac? If so, please add this fact to your forum profile.