Calling up tables across sheets based on dropdown

Hi,

I'll try explain as simply as possible!

I have a sheet with multiple tables on it, the formatting of the tables is required by my employer.

I have named each of the tables as a range.

On another sheet I want to have a drop down list of table names, with a replica of a table below it. The table will autofill will the matching data based on the selection of table name in the dropdown list.

Do I need to enter a formula in each cell of the replica table, if so could someone assist with the formula please?

Or am I missing an easy way to do this?

Sample attached.

Thanks

Are all the tables the same shape in the data sheet?
Is your example representative and all the tables appear on the same data sheet?

Also you have a space between table and number in one shet and not the other table1 vs table 1

This is a bad way to arrange data but
b5 =INDEX(Data!B:B,MATCH($B$2,Data!A:A,0)+1)
e7=INDEX(Data!E:E,MATCH($B$2,Data!A:A,0)+3)

etc etc

It would be much easier the data being in a big table and you search for employees and it shows their results in the format in the lookup table. Bosses often have fixed views!

If none of the above is true, post a representative spreadsheet to get a workable answer!

Thanks davsth, this works well.

I agree, not a good way to present the data but change happens slowly around here!

Many thanks