Hi all, I'm having trouble creating a master sheet that reflects the contents of certain cells on other sheets. The function works, but there are a couple problems. Here's what I have so far:


='Sheet 1'!$C$30 ='Sheet 1'!$C$37 ='Sheet 1'!$C$44
='Sheet 2'!$C$30 ='Sheet 4'!$C$37 ='Sheet 4'!$C$44
='Sheet 3'!$C$30 ='Sheet 4'!$C$37 ='Sheet 4'!$C$44
='Sheet 4'!$C$30 ='Sheet 4'!$C$37 ='Sheet 4'!$C$44
='Sheet 5'!$C$30 ='Sheet 4'!$C$37 ='Sheet 4'!$C$44
etc.


First, I would have to change the "Sheet #" by hand over 700 times unless there's a better way. What's the trick?!?

Secondly, that function returns a "0" when nothing is typed in that cell, but I want it to stay blank instead. Is this done as part of the function with an IF, or some other way?