Hey Jake-
The new code seems to return a blank listbox1. Also by eliminating column F in the named range, will that prevent it from being loaded and then later inserted into sheet2?

Thanks,
Mark