2 tabs. 1. This will be the input tab, 2. is where I have the data. I want to
be able to look up data from tab 2 when in tab 1 cell 1A data is inputed. But
it needs to return 20 columns and the rows may very from day to day.

Say I put LAX in 1A, I then want to have a code that will look up LAX on the
tab 2 1A:5000A or there about, and return data that is,1. all cells with LAX
in column A and it's ajasent row data.

So the in results should look like this:
Org Dest Ship Date Billto Customer Number (this row will be fixed)
JFK LAX 20070716 014336140
LAX LAX 20070619 014298771
LAX YUL 20070508 014109631
LAX RDU 20070523 014314554
LAX LAX 20070719 010201376
LAX MCO 20070517 014318662