如何使用VBA用户窗体循环工作簿中的多个工作表

Just updated My data so you could see. It wroks for 1 worksheet since I am referencing that worksheet. Still having a hard to figuring out how to reference the whole work book so it will look in all 31 worksheets for the name. I am also haveing trouble figuring out how to go to the next record if the Patient is in there more than once a year. Any help is greatly appriciated.Just updated My data so you could see. It wroks