Macro to create summary sheet from multiple worksheets

[sarah412]

Hi all -

I'm trying to create a macro to create a summary tab that has 5 columns. First in each workbook, do the following formula: =(RIGHT(A3,4) into cell A87. Then, Columns A-D in the summary tab would be a copy of A87:D87 from each workbook. Column E in the summary tab would be the formula (from each worksheet):
=IF((MAX(B70:D81))>-MIN(B70:D81 ),MAX(B70:D81 ),-MIN(B70:D81 ))


Thank you all so much for your help in advance!!!
</pre>