Use data from a cell to make a dynamic file path

I'm so lost here. I'm trying to make a vlookup path change depending on a date chosen from a dropdown.
Essentially I have a summary page that calculates sales based on current month, or prior month if you choose the month in the dropdown. I'd like the file path to use the date in the dropdown to "dynamically" fill in the path name.

My date looks like - Nov-19 (mmm-yy)

I've tried concat and other ways but nothing is making sense.

Also it it's probably an important note, the date the vlookup is going to is in a separate workbook.
The bolded parts are what would need to swap and reference the dropdown text.

Thanks!

=IFERROR(SUM(VLOOKUP($A3,'\\FILEPATH\[FILENAME.xlsx]TAB'!$A$3:$AM$6, MATCH($AN$2,'\\FILEPATH\[FILENAME.xlsx]TAB'!$A$2:$AK$2), FALSE)),"0")

Thanks 6StringJazzer, I'll give that a shot! I can leave the file open if need be.

that worked perfect, thank you again 6SJ!

Originally Posted by 6StringJazzer

I'm glad to hear it worked--I typed it straight into the posting without testing it.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon Attachment 651612 below their name.

Will do, thank you again!