VBA/Macro to automate clicking multiple buttons

[Excel_NoneTheWiser]

Hi

I have a task I perform weekly where I need to press an 'Update' button on 6 different spreadsheets. I just wondered how easy it would be for me to create a macro or some VBA to automate this?

It would need to open a file, press 'Update' on the first pop-up, then click the actual 'Update' macro button that updates the data in the sheet from a Pi-Datalink and then save the file, close the file and repeat the process for the other 5 files.

I'm wondering if anyone could help with that, as I have no experience with VBA.

Many thanks in advance.