I can manually extract the "AAAA" or whatever the list name is, if somehow the row containing the cell of the partial match is copied over into the final worksheet, with the other details as specified above