Update: I still can not get any of the queries to update and include the new data when I click refresh or refresh all. So far, on one occasion it just failed to pull any numbers. I checked the criteria and it my "begins with" constraint like all the other queries I have made and it will not pull the rows for whatever reason.

So main problem: query will not update to include new data pasted into the original data table and not really sure why.

I noticed when I went to edit the properties that the range of the query was fixed, is that what my problem is and how might I fix it? Thank you again for any input you have.