Help with linking sheets together.

I have linked information between sheets in the same workbook. I was wondering if anyone knows of a way to have the information from sheet A appear into sheet B but in a new line. It is kind of hard to explain. I'll attach pictures to make it easier. Screen Shot 2013-01-02 at 10.47.55 AM.png This image shows the sheet the information is going to. As you can see i already have it linked using 'Trailer Summary '!F5 for example. Screen Shot 2013-01-02 at 10.48.09 AM.png What i woud like to do is be able to type in F5 on the Trailer Summary sheet and have it come out in the other sheet as a new line without deleting the information already stored there. Is this at all possible?

Thanks

Trailer %2F Dock Control.xlsx

This is an example of a sheet.

I would like to be able to type in F5 on 'Trailer Summary' and have it come out in a new line on '53902' below row 4.

robert, welcome to the forum

not every1 can open .png files, myself included. It would be far better if you could upload a sample of your file, showing what you have, and an example of your expected outcome. Thanks
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

will you have a sheet for each of the trailers, and only 1 project per trailer?

and the info will be entered into the trailer sheet, and then pulled into the "53902" sheets?

I have this so far...
=VLOOKUP($B$1,'Trailer Summary '!$A$4:$K$17,MATCH('53902'!A$3,'Trailer Summary '!$A$3:$K$3,0),FALSE)
however 2 things...
1. you have headings in sheet2 that dont appear in sheet1. i designed the formula to use the column headings to bring back the data so you dont have to mess around with "how many columns"
2. if you are going to have more than trailer # on sheet1, what would distinguish them apart? could 1 of the load dates be used to make them "unique"? (ie combining the trailer # and a date to create a unique ID)

Trailer %2F Dock Control.xlsxOkay, so you are saying i need the same heading on each sheet? The only information i need to transfer is in the next doc i will upload. The yellow highlight represents the to be transfered onto '53902' and the green is what has been transfered. The red is what i would like to type into 'Trailer Summary' F5, G5, I5 and J5. Then appear on '53902' just like it is, without erasing the other.

The date could be combined with the trailer # to make them unique if the trailer numbers aren't unique enough.

we need to have something else typed onto "53902" sheet, to make each trailer row from sheet1 unique. you already have "53902" in cell B1, so now we need to add/combine with that to find the unique row in sheet 1. any suggestions? I thought about using 1 of the dates, but then you would have to type that into sheet2 as well, and it looks like that is 1 of the fields you want to have returned

no, what im trying to get to is, if you have 2 (or more) entries on sheet1 that are for 53902, how will you tell them apart? we have the 53902 as 1 part, we now need something else from the row that will make each 53902 unique