I looked at your code and it is basically what I have been trying to do, but you bring up a very good point. I cannot find anywhere how to associate those 24 tables that are on the MAIN GOE RECONCILIATION worksheet. I think this is what my problem is. For example, one table in this worksheet is labeled "State" in the Table Name in Design tab and the worksheet name on the tab is MAIN GOE RECONCILIATION. The Table Name upon which I am trying to pull the data from (one of 24) using the "NO" dropdown is titled "StateProgramTravel" in design field and its tab name at bottom is 21000 State Program Travel. I believe this is the issue I am fighting! Any recommendations or guidance? Do I need another table in my workbook that brings these two together. I only want the tables in the MAIN GOE RECONCILIATION worksheet to include the selected cells identified in main post.

Thanks for any help you can provide.