Querying Google Sheets for Dynamic Tables

I currently use Google Sheets as the database for my blog and then render tables using awesome-table for the site.

Awesome-table works great and ensures that any updates in the spreadsheet are carried across to the site almost instantly.

However, I also have other data that I would like to be able to show on my page, this data is large and consists of 10’s of thousands of rows so I don’t want to just have this as a dedicated table. What I would like to do is have a dropdown menu (allowing only a single selection at any one time) and then have only the data that corresponds to that selection rendered on my blog.

For example, if my spreadsheet had the following data:

Name Age
John 30
Jay 20
James 24

I would then have a dropdown menu that selected say “John” and the rendered table would be:

Name Age
John 30

I’ve spent lots of hours searching how to do this (I’m no coding expert) and finding that I’m getting too confused with all the information out there. As this is a very common thing to have on websites I’m assuming there should be a fairly simple way of doing this?

Any help is greatly appreciated

Note that my blog is dailyfantasysportsaustralia.com, however I don’t have a specific page set up yet with this issue as I’m trying to find a starting point.