Running 3 different macros across selected multiple worksheets in one workbook

Excellent. Thanks very much. RunBigCalibrate and RunCogcalibrate work perfectly. Unfortunately the worksheet names for the third macro are of varying lengths. I am writing the macro now and will get back to you once I have finished and tested them. Is there an option to maybe tell this macro to omit sheets instead of telling it to find specified sheets?

To 'omit' like you wanted, probably like this:

Sub RunCalibrate()
    Dim ws As Worksheet
    For Each ws In Sheets
        Select Case ws.Name
            Case "WP", "NS", "BIG", "Contents", "Instructions", "DescriptiveStats", "CalibrationSummary", "Data"
            Case Else
                ws.Activate 'use this if your macro requires the worksheets to be the active sheet to work
                Call Calibrate
        End Select
    Next
    Sheets("Contents").Activate
End Sub