Automated Mass Spectrometry Data Normalization Pipeline

Design an advanced Excel VBA macro that can automatically process large-scale mass spectrometry datasets, performing multi-stage normalization across complex protein identification experiments. The macro should handle variable input formats from different spectrometry instruments, apply statistical outlier removal using modified Z-score methods, and generate comprehensive statistical summary reports. Include error handling for non-standard data ranges and create conditional formatting to highlight significant molecular weight variations.