How do I source and initialize data from multiple sheets with one VBA code?

Hello, I am new to VBA and found this code online and modified it to fit my purpose. However, I have a multipage useform and would like to be able to load data from different source worksheets into the userform. Each page has differently labelled combo/text boxes e.g. Page 1 would borrow data from sheet3 and place it into Ctrl1 and text2 etc, while Page 2 would borrow data from sheet1 and place it into CtrlX1 and textX2.

Code:

Please Login or Register  to view this content.

I would like to source data from sheets 1, 2, 3 and so on and load it onto comboboxes/text boxes on the multipage userform.

I desperately need your help.