Permanent Sorting Column Sheets

Please allow sorting to be permanent on a sheet.

My Issue

We log our trucking miles and have a sheet with current and previous miles columns along with other information. Those two columns pull from another sheet filled out from submitted forms. Our main sheet will reference the most recent miles submitted and the previous miles submitted. It works as long as you manually sort the form sheet. The only way to have a permanent sort is from a report, but we can't reference it to a sheet.

Is there a better way to do this?

I have submitted a product feedback form, but have seen several people being requested to do the same for 4 years.

Thanks

Answers