Excel 2007 : Any formula to copy a text from a cell to another

Hello,

Please any formula out there in Excel that is copying a text from a cell to another like the way we used to do with numbers and sum formula!?

Thanks

I mean, I am working as an accountant and I need to have many entries per day.

So I add some entries to some sheets and want to grap the contents of some cells into another sheets.

The contents is a text and not a figure.

For example sheet 1, cell a23 include the text "Payables".

I want to copy the contents of cell a23 in sheet 1 into sheet 2 cell d56.

and I want the copy process to happen automatically as soon as I added the entry in the sheet 1, cell a23.

I hope that I did explained it correctly.

Thanks