VBA macro to automatically trigger a refresh on a power query once a new file is received in folder

Job ID: 34186679

Budget: $30 – $250 AUD

I would need a macro vba option that will action a refresh on the power query Folder DB every time that a new folder is added into the Folder DB.
I would need this action to be triggered without the need to press any button, only as soon as a new file is added into the Folder DB. Please assist and confirm
Related categories: Visual Basic Excel Visual Basic for Apps