I was looking to do the following.

I have a workbook. 1 sheet

Column A is for Name

Column B is for Amount

Column C is for Account Type


The following is what I am trying to do.
By running a macro, I would like like excel to see if the specific Account Type (Column C from Wrk book 1) Workbook is created (The workbook would be in the same directory if it is created). If the workbook exists, then go to a specific sheet - all sheets are named after the Name in column a or workbook 1. Then put the amount in the exact Name sheet in Cell A4.

Any help would be appreciated.
Thanks in advance

Josh