How to make a filter display other sheets in Google Sheets?

Question

Google Sheets

I have 3 sheets in my google sheet (sheet 1, sheet 2, sheet 3). Three sheets have the same tables. The difference is only in the data (no data in 1 sheet). I need to make a filter in sheet 1 that will select a sheet (2 or 3) and display its information. How can this be implemented?

Answer 1

=arrayformula(ДВССЫЛ("'"&A1&"'!A1:Z"))
A1 contains the name of the sheet - you can make a dropbox with data validation tools
A1: Z - copy range