Not quite sure what you mean here:

.... One question I have is can I use these forumulas on a separate sheet within the same workbook? ......

Isn't that exactly what the example does?
Do you mean if the formulas can be used on more sheets within the same workbook?

One more question by the way - will your table always contain only "1" or blank?