I have about a hundred workbooks that I need to modify and I'm hoping to do that without having to open each one up individually. Each workbook only has data on one sheet.

Briefly, I need to insert four columns in between 'H' and 'I'. These columns will have fixed titles across all the workbooks.

Is it possible to do this by macro rather than opening up each workbook individually and inserting then re-naming each column? Looking for any guidance...

Thanks!