modified code loop throughout multiple sheets instead of one sheet

hi
in earlier time I got help from mr.jindon in this thread https://www.excelforum.com/excel-pro...-of-three.html
it populate data based on sheet inventory when select combobox(1,4,7,10) will populate data in other comboboxes and textboxes based on data in sheet inventory . now I would mod the code by making it when select the sheet name then should populate the data when select combobox1, 4,7,10 based on selected sheet from combobox13
I hope some body help