Iferror and vlookup in a formula to combine data from multiple sheets into a one sheet

I notice that my formula is only check one sheet retrieve the data and stop. It does not check the other sheets and pull that data to added to one sheet. For example, looking up item that is on two s...