Fill out a ranking using data from other pages

Hi everyone,

I'm not a particularly frequent excel user, and I'm making a silly spreadsheet documenting the reviews my Australian friend is giving to British crisps.

Each crisp has a picture on the home page, which when clicked takes you to the individual review of the crisp. She has ranked each crisp with different categories and given it an overall rating.

I would love for each "overall rating" to go to a final page on the spreadsheet which shows all the crisps in ranking order. Now, of course I could just go through and type them in, changing them each time she reviews a new crisp, but is there a way excel can take this information with a formula?

For example, on each individual crisps page the overall rating is cell D8. If a quaver was rated 8.5, a pombear was rated 6 and a mini cheddar was rated 7, could excel automatically put them in order of quaver, mini cheddar, pombear on my final ranking page?

I appreciate this is a very long winded way of getting it across but it's a bit niche and so I wanted to try and make it clear! (It's much easier to just show someone a video of the spreadsheet but I don't think I can do that here!)

Thanks!!