okay, I've found a few issues. #1: I'm dumb. The road names are in B and not A. #2 in the Copy Destination, it is listing Sheet 2 ("A1"). First, nothing is transferring to Sheet 2; everything is going to Sheet 1. Second, does the "A1" limited the responses to only 1? Would it have to be "A:A" so that all of the responses returned by the query will go into the A column and not a single field?

Forgive me, I'm completely naive to this type of action, so I don't have a grasp on the logic.