Linking data between sheets as it is added

Hello all,
Im making a workbook (excel 2010) for sales data on my website and have a few questions. Each Sale has a specific order number associated with it. I enter it into spreadsheet one and it calculates my profit based on a lot of different factors.
Spreadsheet #2 is my returns and credits sheet.
Each order number will be placed in column A
Is there a way to link order numbers as they appear, for instance if I enter in order #234 in spreadsheet #2 it will take me to that order in spreadsheet #1. I know how to link data that is constant across spreadsheets, but this data will be added as we go.

If this is not possible, another thing that would help would be to highlight the order number cell in spreadsheet #1 if it appears in spreadsheet #2.

Thanks guys

https://www.dropbox.com/s/y41bi1df1r...uary_Ebay.xlsx
The file was too large to upload via the uploader, there is the dropbox link for it.
I am tring to match the Record number in column "b" in sheet "shipping" with the record number in column "c" in sheet "returns"
Ive also been tring to write a statement that if two record numbers match, the value in "cost, column k, sheet returns" will be transposed to "cost, column Q, sheet shipping"
Thank you for your quick reply.

took screenshots of it. File was too large to get down with two sheets.

Excel.PNG