How do I make it so a file that will automatically update for everyone who has access?

I will start by saying I’m not the best with excel so forgive me if this is worded improperly or I misuse terms.

My job uses a huge excel file with three sheets for data. When an issue is closed out on one page, that data from the row needs to be moved over to the last page.

Currently what we’ve been doing is every couple of weeks we’ll send out an “updated” version of this file with all the data moved to the last sheet. It takes a long time to move all this information to the last sheet and everyone now has to save a new version of it to their computers. Rinse and repeat.

I want to create a “live” file that I can move the data from one sheet to the next and it will update for everyone who uses the file. Then we won’t have to save a new version anymore or spend multiple hours compiling the info that’s been finished and moving it over. Is there a way to do this?

Thanks in advance for your help.