I have items listed in various ranges through multiple sheets.

I have Named Each range such as "PartNoBlue", "PartNoYellow" etc

I want to populate a Listbox on a form with ALL the Named Range Values
across all sheets, but have been unable to get the correct syntax.

I also tried a Named Range that included ALL Values of items across Multiple
sheets, but it returned an error.

How can i populate the Listbox with Multiple named Ranges correctly, and
also remove any Spaces?

Corey....