Welcome to the Board!
The way I usually do something like this is change your query to SQL View, and copy and paste the code out to something like Word, NotePad, or WordPad. Then do a simple Find & Replace, replacing the name of your old tables with the names of the new ones. Then copy & paste that code back into a query in SQL View, and you are good to go!