Listing the sheet names on the dropdown list and getting some values from the selected one

Hello all from newer,

I need your help with my project if possible.

My project is like below :

I will have a workbook which has maximum 25 sheets.

On the main sheet, I will have a dropdown list which contains the sheet names and these names can be automatically updated when adding or deleting the sheets.

When I select one sheet name on the dropdown list, some values in selected sheet will come to the main sheet.

Is it possible and can you help me about this project?

Best regards.

This my project template. When I select the sheet on the dropdownList, the measurement values should brought down to the dropdown list

royUK thanks for your reply. Your solution updates the pages deleted or added ones?