I'm hoping this is an easy question. Each month I run 5 reports that are
saved as excel workbooks. I have a macro template that combines and analyzes
the data from the 5 reports. Each time I do this I copy and paste the macro
template into a new folder and save the current 5 reports in this new folder.
Each of the 5 reports is saved with the exact same name.

What I want to do is change the formulas in my macro so they reference the
five reports I run without having to copy and paste them into the macro
template workbook. Is it possible to reference worksheets saved in the
current directory by not using the full path name (because the folder this is
stored in changes every month). I know its possible in html so I'm hoping
its as easy in VBA.