I want to add formulas from multiple sheets to master form

[snake941]

How do I add formulas from multiple sheets in a workbook to a consolidated
worksheet?

 

[Fred Smith]

Maybe something like this:

=sum(sheet1:sheet5!a1)

Regards,
Fred