Well, I'm afraid your extra detail did little to make your Excel application any clearer. I find it still quite confusing. In first place, "I have a range of "1" and "0" makes no sense. A range is a cell or group of cells given a range name. That range can then be referred to in formulas rather than using the cell address (A1, B1, etc.). And "1" and "0" are not valid range names.
Then, you go on and say, with reference to your "range of '1' and '0'", that "that is all in sheet one." Then you say, "I want to transfer all of those "1" entries from my sheet 2". Sheet 1, sheet 2, ..., which is it? Then, you mention "the schedule that the employees see -- a very easy to read calendar" as being in sheet two, but then say, "I want to transfer all of those "1" entries from my sheet 2 to the appropriate spaces on the calendar in sheet 3." Sheet two vs. sheet 3, for the calendar?
Have you had any formal training on Excel? Do you have Microsoft Access? Do you know anything about it? Have you ever thought of converting this application to Access?