Cell drop list of workbook sheets

Hello

Is there a way to have a drop list of all the sheets in a workbook in selected cells and the selected sheet from the list, populates other cells in the first sheet?

I want to easily see what machines are connected to a list of RJ45 wall points. In the workbook, there is 1 sheet that has a list of wall point and each machine has its own sheet. Each machine sheet has lots of corresponding data that is not pertinent to the RJ45 wall point sheet.

My goal is to select a cell next to a given wall point row in the RJ45 wall point sheet, that drops down a list of machines (that are all the machine sheets in the workbook). The dropdown list selection will populate pre-defined adjacent cells with corresponding data  from the selected machine sheet.

1. Each cell in the MACHINE NAME column has a drop down list of the sheet names to select from.
2. Once a machine is selected, the hardware names and model columns that are on the same row are populated with the corresponding data on the machine sheet.