Hello,
I have attached a worksheet that I need some help on. I have created a master sheet and in this I want to pull certain data of every player from the 'OnBall' sheets - I can get this working for one 'OnBall' sheet using a VLOOKUP but is there a way to add the values required from all the 'OnBall' sheets and can the addition be automatic if a new sheet is added?
also, the real names on the 'OnBall' may change position or be completely different.
many thanks,
sergio
Bookmarks