Can calculated data from one sheet create a row with results on another?

[Kolvir]

I have a spreadsheet to track various sales. On the main summary sheet I have just a description, amount and source of sale(like ebay or local). Another sheet I use to calculate my net from ebay sales, with calculations for ebay and paypal fees and shipping charges and costs. I have another sheet for a different site.

Currently if I sell something on ebay I enter the data on the ebay sheet to calculate the net, and then manually enter the description and net on the main summary sheet. What I wonder is if it is possible to have the net, description, and source(ebay in this case) automatically entered/transferred to the summary sheet. I’m willing to research how to write a macro for this, but need to know if it is even possible.

[Kolvir]

Should I do this in a database instead?

[erAck]

You can reference cells or cell ranges from other sheets by specifying the sheet name in a formula expression’s cell reference, best prefixed with a $ character for an absolute sheet reference in case you want to copy&paste such formulas to other sheets as well, for example $Sheet2.A1 or $Sheet2.C1:C3. If the sheet name contains blanks or other special characters it needs to be enclosed in single quotes, $'Second Sheet'.A1 and if a name contains a single quote that needs to be doubled to be escaped, as in $'Shop''s Sheet'.A1

[Kolvir]

That I know, but can I enter data on one sheet and have it fill data on another? I don’t have just one cell I want updated, I want a new row populated.