Copy/Filter Results That Are Not Blank/Zero From One Worksheet to Another

Hi all, been messing with this all morning and I've finally given in.

On the attached workbook, I am needing all rows that are not blank (or zero) for Sheet1 Column D6:D48 to auto populate (in order) D6 onward on Sheet2. Sheet3 is the end result I am trying to obtain, what would change as I modified Sheet1. I was looking at other threads and playing around with AUTOFILTER this morning trying to get it to work, but I am completely out of my depth here. Any help would be greatly appreciated.