Automate current process utilizing VBA - record data based on various filter combinations

Please see the attached Project explanation with illustrations.xlsx file.
Also, please see accompanying files:
BASIC MEDIAN FLUCUATIONS.xlsm
Input sheet MEDIAN RESULTS PROJECT.xlsx
Results sheet MEDIAN RESULTS PROJECT.xlsx