Hopefully I can clarify.

When I drag the formula down to populate the rest of the spreadsheet, it drags the exact formula down instead of changing the column reference. I know currently it shows as $D$5 but even when I change it to D$5, the column reference doesn't change (because the data I'm getting the information from is setup with each product as a column and the sizes as rows. I'm trying to copy information into a section that is orientated with the sizes as columns and the product as rows.

I was just hoping there was a way to have it "move" the column reference as I drag the formula down instead of having to manually change it to the column I need.

Does that help?