the data is text.
Sheet 1: Template
Sheet 2
Sheet 3
Sheet 4

the information that I am wanting to pull will be from the same cell in sheet 2, sheet 3 and sheet 4. I am just wanting to make sure it pulls data from one of the sheets and stores it in the template. sheets 2-4 will have the same information but sometimes sheet 2 will be blank so I am wanting to then go to the next sheet to pull that data