Scanning barcode data into a cell, say A1, and need to reference this
data to another sheet that has this same data which was imported from
buisness software that has relevent data in the row which I want
transfered to the first sheet into cells A2, A3 ect..

Example: I scan the Job # into Cell A1. For cells A2, A3 etc, I need
to look up data in another sheet referencing the data in Cell A1 (same
Job #) such as PO , Customer, Date... then this data would end up in
A2, A3, etc.

Thanks,
Tom