Formula help: Linking other workbooks with changing names

Hi

Please can somebody help!

I am trying to create an analysis of employee's timesheets- each timesheet has a month's data inside and an analysis of the month. Each workbook is specific to an employee. Each timesheet is titled Jan 2023, Feb 2023 etc.

I know it is possible to insert data from an employee's timesheet by pasting the link inside my analysis workbook, however to help automatically generate a new analysis for each month, is it possible to automatically generate an analysis for every month- for example by keeping all employee's workbooks the same name format e.g March 2023 (then carrying out a lookup in the March Analysis workbook).

The formula that I would like to change if possible is:

='S:\MI6\Timesheets\James Bond\[March 2023.xlsx]Month Analysis'!$B$2

Changing the March 2023 to whatever the month of the year is

Many thanks in advance

See example below:

For any analysis required some data. Give enter your some data in format, specifically time format as hh:mm:ss
Also note that, for productivity requires total working day, total present days

Here i have attach some workbook. Kindly go through, change as per your data structure accordingly.
In summary file, with data validation you can select the file.

By choosing file name > path > See the formula in summary sheet which is self explanatory.