how make rowsources for multiple combobox from multiple sheets in the same colums

[p45cal]

hi p45cl it shows me error when i run the form
in this line

Sheets("Append1").Range("A1").ListObject.QueryTable.Refresh BackgroundQuery:=False

Without you having made any changes at all? That is, does it run properly as I attached it?

What version of Excel do you have?