What's the difference between Transfer Number and ID Number ?
Is the date for a given Transfer Number on the transfer log always the same ?

I ask because I wonder why the Transfer Form has both Transfer Number and ID Number and only one location for date.

If you don't require dates when copying your data, you may want to use range.find and .findnext rather than vlookup.
If the dates could be different, and you want them with the rest of the data, you could just filter and copy the transfer log.