Pulling data!

[Cowells01]

Hi guys, I have two workbooks (workbook 2 has two worksheets) I want to pull data from both worksheets by choosing, maybe from a drop down, the correct worksheet. Data has the same headers. Final thing is workbook 2 changes it’s name each week! Can I put the name into a cell to reference the search workbook in workbook 1. The files sit on my drive but will move to teams/SharePoint in the future.

 

[EXCEL MAX]

I think it's not possible without using VBA code.
You can recognize newly opened workbook only with VBA.