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?