VB- Search Directory, Update Master File From Multiple Files

Here is a project I can’t seem to do on my own if you can point me in the right direction I would be grateful! here is the best suedo code to describe the needs of the script:

In the open workbook named MASTER, on Worksheet named -MASTER- ( Let’s refer to this all as just MASTER)

(In production, the name of this workbook will be an account #_ date, and the worksheet will be a date)

For each numeric value in row 6 (we’ll call these values AD###) of MASTER

'*****Part one of routine*****

Search directory "H:AccountingAdvertising Accounts" for workbook named AD### AX.xls

(Note the AX suffix of the file name)
If match is found open workbook and proceed to Part two

If match is not found, goto Private Sub AD_MISSING

'*****Part two of routine*****