matching data rows from one sheet to another for a data return

I need help matching data from one sheet to another.

For example:

I need a formula that matches the customer name on sheet 1, to the customer name on sheet 2, but returns all relevant data on the rows such as:
Acct No; Cash-OnHand ; NonCash Amt; Non-Cash Code; Total Deposit; Deposit Guide Estimate


Can this be done?

Thanks everyone, I need all the help I can get with this. The Spreadsheet is only a small sample of the monster I have to go through which has about 80000 records.

I have one sheet that contains 1 Group Name (ex: isle of venice) and the 2nd sheet that will contain all the detail associated with that name.

What I am trying to do is create a formula that will find the name on the 2nd sheet and provide all the account detail associated with the names on another sheet. In many cases, one name will have more than one acount, therefore I would need the detail for each row. Instead of me having to do the equivalent of CTRL+F and Copy/Paste the rows which will take forever.

I actually don't need to SUM the data because the SUM'd data is what I have on sheet 1. So I have 300 condensed names and those names appear within the list of 80000. So I would need a return on the exact data per row that matches the name on sheet 1.

the name would be the common denominator, and the rest of the data is unique to the Account Number

wow! thanks, that is a super long formulat that i would never be able to create. Thanks so much. Let me try it out to see if it works and it will let you know.