INDEX and MATCH or LOOKUP formula.

And what do I do with these?

What is the source? what is the target? where is the pattern? where is the data?

And please don't post files of half a MB with nothing in them. There goes my data plan cap again .... For nothing.

Sorry, I did realize it was that big, if I delete them will that help with the data plan cap? I am not doing this on purpose, so I will apologise again.

I will repost the first file because that is the one I am really needing at the moment.

I entered the formulas and you should be able to follow how it needs to flow. I am taking your advise of making a raw data sheet and have it automatically appear in the sheet that needs to be printed out. The pages go in order from 1 to 4 and so on. I hope this makes it clearer.