running same column formulas on multiple Excel files (not sheets)

[subject_matter]

if i have 101 separate excel files each with a different name and i happen to have created several column formulas in one of these excel files, i wish to automatically run the several column formulas simultaneously on the rest of the 100 excel files in one go.

how can i get to do this?

please note that all the 101 files are completely identical with only difference being each has its own unique numerical data in columns.