Linking data validation cells to each other to then display information from a specific sheet and row/column.

Hi everyone, my first time posting here in search for help with a problem I can't seem to figure out by googling.

I have some sets of data, organised on individual sheets into table (different properties in the first column and values for the properties in the rows) such that I would want to be able to use some drop down menus to select the sheet, followed by the column from the corresponding sheet and the row of the corresponding sheet to them display the specific value I am interested in. The goal is to basically be able to do a type of side-by-side comparison of things from large data sets, but focusing on specific properties.

What I thought I might need is a data validation cells for the sheet names (only several values) but then I tried to use the indirect function to create a way to retrieve the other info I was after but it didn't really pan out for me.

Any help would be much appreciated.