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: