Macro to Copy/Paste Data from One Sheet to Another

Hey guys...I've run into a snag that I think has an easy fix. I believe that i know how I want this process to run, I'm having trouble executing it.

Here's the details: I have a spreadsheet (see attached image) that contains a record of time (in months) running across the sheet (the columns) and down the side (the rows) is a list of products. Within these cell blocks (divided by month and product) are some dates pertaining to order shipments.

I am trying to create a macro that will loop through each row and determine if the cells cantain data, if they do contain data I would like that copied and pasted to a new sheet. After copying/pasting the shipment data the macro will have to copy/paste the product name from column A of the applicable row.

Essentially this will build a user firendly database that I can easily organize and work from.

Please feel free to inquire if I did not explain this well.

Thank you in andvance for any help.