Try like this
[f:\Finance\monthly_summaries\*.xlsx] (ooxml, embedded labels, table is [EOM_SHEET$]);
Is F: drive is your local machine drive? If yes it will work otherwise if it is shared drive the you need to give the actual path like \\10.10.29.38\SomeFolder.
No need of Loop, hope it helps you.