Creating a Master Sheet

solution provided by @kaper is more comprehensive and answers your question fully.

But addressing this particular issue only:

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

"the trick" is to simply select the relevant cells and use "Find and Replace"

Find and repace.jpg