Linking Drop Down Lists across Worksheets

I don't read anything in your post that I didn't cover above. Step #2 shows you the formula needed to make your PartsList named range dynamic. It will only show the values above 0 from the range, I promise.

The garbage sheet itself should have enough extra cells in the copy range (Step #1 above) to handle your expansion, and as a result the cross-sheet references WILL result in zeros at the bottom. Don't fret it, it's a garbage sheet, right? You can even hide that sheet so no one even gets to see it and complain.

As for your signature, click on the USER CP link at the top of any page, then click on Edit Signature on the left side-panel.