When the macro runs, a user is asked if information on sheet 1 is relevant; if yes, the information on that sheet is copied and pasted to the current sheet (CODESHEET UNSORTED). There are 15 sheets prompted and each one can be answered yes or no.

At the bottom of the CODESHEET UNSORTED, all of the copied data is summed and the values are compared to a bid summary sheet to make sure the user didn't forget to include any sheets with information on them.

That is what this will eventually be used for (conditional formatting to ensure the values match) but I can't figure out how to set that value as a variable to use throughout the conditional formatting.