If you have a real date in say cell E1 you can put together a file name like this:
="OpsMeeting_" & TEXT(E1,"m-d-yy") & ".xlsx"


What you do with that depends on how it's going to be used.
Are we talking macros?
Or only stuff on a sheet?
Is the workbook you're gaining access to open or closed?


Are you wanting to refer to a range in that workbook, a table perhaps, a single cell?

Are we talking macros? No Macros
Or only stuff on a sheet? Only data on one sheet
Is the workbook you're gaining access to open or closed? Open
Are you wanting to refer to a range in that workbook, a table perhaps, a single cell? Want to reference a few cells on the sheet.

Thanks for replying quickly!