copy data based on workbook name

Good Morning, i need a macro that will return the workbook name without the extension and based on that name, copy the appropriate data from a sheet to the master sheet.

I attached an example.

Thanks for the help

Your example doesn't really help explain what you need

I've updated the workbook example.

So the workbook is named 57 - 58. xlsx

The Master sheet should look like this after running the macro

B1 = 57 - 58 (the name of the worksheet, without the extension)

D1 = B3 from the "find here" sheet (based on the workbook name, return the data)

F1 = C3 from the "find here" sheet

H1 = D3 from the "find here" sheet

all the info that needs to be copied is found on the same row as the workbook name. So the macro has to find the right row from which to copy the data

Hope I explained better now.