Compare Lists & Copy Data

Hello,

I need some help with a macro that is working in a very large data base, Im attaching a dummy workbook to assist.

I have two list one with just Z#'s and one with Z#'s and information, I need this macro to reference the list of numbers and if they have a match to copy them. It gets a little complicated because the first 8 digits are unique and there is a possibility the last two change.

IE
Z1234567800
Z1234567801
Z1234567802
Z1234567803

The first is like the master record and the subsequent #'s are attached to it changing the last two digits. The list will only contain the the Z# ending in 00 but I need to pull all the Z#'s that are associated with the first 8 digits.

I tried using an auto filter macro with a bunch of And operators but it didnt work

Please let me know if I can awnser any questions that will help with this.

Thank you