need to pull information from two separate spreadsheets using the same patient information

I have 2 Excel 2010 spreadsheets and I want to take the Patients from #1 spreadsheet and pull them from #2 spreadsheet by the patient # also pulling the charges and collections.