Thank you for replying Paul!
I've been toying with this for 2 days (the first 2 days of toying with VBA at all) and this let me dump the file name into my sheet to pull from with my macro. This is great and has shown me there is still a TON for me to learn. Currently I understand about 30% of what each section of code does but it works for now and I'll be studying what you did so I can learn from it.

Thanks again!