Applying same formula to multiple workbooks

I have a folder of about 20 Workbooks. I have a series of formulas that need to be applied onto all of these workbooks. Each workbook in the folder has values from A2:E722, with a header on the first row. The formulas refer to the values in this range. I have a formula for mean in column F, median in Column G. and average in Column H. Is there a way to apply this formula for all the workbooks across the board. Rather than copying and pasting the same formula to each workbook?

Try something like this code...

Please Login or Register  to view this content.

as in attached workbook.

thank you sir