Only Reference cell with data in them
 

Im using excel for two reasons. One is to make a work schedule and the
other is making individual sign-out sheets for people to use. The worksheet
contain the same information (Names, hours, location est.). What Im trying
to do is pre fill out 20 different the sign-out sheet from the schedule (not
40 of them). The problem that Im having is that blanks in the schedule are
causing blank sign out Sheet to be filled out.
So Im trying to reference cell only with information into another spread
sheet. If you understand this can you help me?