Generate Sheet based on other sheets

So I have 3 Sheets: Entry, Location 1, Location 2

Location 1 Columns: Date, Description, Amount
Location 2 Columns: Date, Description, Amount
Entry: I want new lines to populate every time I enter new information into the other sheets. So if I enter in sheet 'location 1': A1=11/1/12; B1=Visa; C1=$500
I want sheet 'Entry' to create two lines


TRNS GENERAL JOURNAL 11/1/2012 Bank Location1 500 Visa
SPL GENERAL JOURNAL 11/1/2012 Gross Sales Location 1 -500 Visa

Can Anyone Help?

Try these 2 formulas...

="TRNS GENERAL JOURNAL "&TEXT('Location 1'!$A$1,"m/d/yyyy")&" Bank "&MID(CELL("address",'Location 1'!$A$1),FIND("]",CELL("address",'Location 1'!$A$1))+1,LEN(CELL("address",'Location 1'!$A$1))-FIND("]",CELL("address",'Location 1'!$A$1))-6)&" "&TEXT('Location 1'!$C$1,"0")&" "&'Location 1'!$B$1

="SPL GENERAL JOURNAL "&TEXT('Location 1'!$A$1,"m/d/yyyy")&" Gross Sales "&MID(CELL("address",'Location 1'!$A$1),FIND("]",CELL("address",'Location 1'!$A$1))+1,LEN(CELL("address",'Location 1'!$A$1))-FIND("]",CELL("address",'Location 1'!$A$1))-6)&" -"&TEXT('Location 1'!$C$1,"0")&" "&'Location 1'!$B$1

place formula to these created two lines. Something like this:
=concatenate("TRNS GENERAL JOURNAL "; a1; "bank location1"; c1; " "; b1)
=concatenate("SPL GENERAL JOURNAL "; a1; "Gross Sales Location 1 -"; c1; " "; b1)