I'm going to do my best to describe this. I would like to create a parameter query where the user selects a filename and the table will display based on what the user selects from the drop down. I know that I will probably need to concatenate the parameters I created. Let me give you an example. On the Song worksheet, in the Anyone.xlsx file, the Anyone Table is displayed. If the user selected Elderly.xlsx from my file_name drop down table I want the Elderly.xlsx table to display on the worksheet. If you have any suggestions or can point me to a blog post that would help me answer this question. I would greatly appreciate the help.