Macro to Copy Data and Paste Values Based on cell criteria

Hi again. I´m developping a tool to create a quick report based on Result Tables distributed on Days Sheets. Basically i want that if i select the DAY i want (in MENU) and next i select the MARKET i want, when i press go the macro goes to the selected sheet and selected MARKET range and copies only the values that are not blanck and then parte the same values in a specific range on sheet reports. In the attachement example, there is a MENU. In Menu we select the DAY we want (DAY1, DAY2 or DAY3). Then select the MARKET we want (Football, Basket or Horses). Then we press GO. Based on cells selection, the macro will go to the selected day and market and copy only the range where there are non blanck cells in that specific market, and then paste them (as values) in report sheet on cell C17. Is this possible?