Getting a result from other (client) worksheet in another (databse) worksheet,help Please?

[samson jerry]

Please can someone help me out here: I have about 10 to 11 worksheets created (in Excel 2010) as client worksheets with their names and the lists of items sold on each of the client worksheet etc. and have another worksheet created which I called database worksheet, I want the number of items sold in all the client worksheets result in this database worksheet and the total money paid from the client worksheets result in the database worksheet. Please how can I achieve this aim?
Thanks you help.

[aydeegee]

If you send a sample of what you want (excluding any sensitive information) we can better understand how to help.

Regards
Alastair