IS THIS POSSIBLE? How can i get it to automatically put in additional lines
as sheet one changes?

I hope this makes sence.

and thank you so much for any help

I don't think vlookup can do this as it just finds the first matching
item. And alternate methods such as Match and Index would need a large
area of formulas defined to make sure none are missed. (and you would
still need a sort afterwards, perhaps) If this is a constantly
fluctuating number of rows in your data, how would you match the
number of formulas needed on the 2nd page? I suppose a complicated
macro could do it, but there is a simple way.

I think what you need is a Filter, or several. Possibly run from an
automatic macro for easy repeated use, per your 2nd post. You have to
carefully create areas for criteria and output when using a filter.
But once it is working, it should be just fine. And it can handle any
amount of data.

I'm not sure if you are trying to return only one card number at once,
or many. That would affect how you design this. One at once would be
easy.