Attached is the spreadsheet that I am working with. I want grab the titles in row 15 across different columns on the outstanding debt worksheet and populate a combobox to create a selection list and remove any blanks. The combobox is on the snapshot page. I have tried to figure this out with no luck. hoping to get some ideas on how to best approach this.