I'm new here and used to used excel back in 200 please help

I'm new here and used to used excel back in 200 please help

Im trying to set up were I can input certain data on one sheet or multiple sheets  and then on last sheet have it auto pull that information from previous sheets to get a full calculations
I.E
Sheets1-4 trip number miles loaded and empty and cost
Sheet five calculates all information on separate rows per trip and one full calculation of total revenue