Macro or Formula to extract data

[incognito]

Hi Guys,

I need some help with a rather large spreasheet that i'm working on. I have attached the worksheet for your reference. What i'm trying to do is extract data from the sheet called P&L and dump it onto the work sheet called Data Extract.

I need a formula or macro that will sense if there's any data in any rows for columns "U" to "AF" inclusive and dump all the data for the relevant months into the Data Extract worksheet. I would also like the macro to copy and paste the corresponding data label for that row from column B.

For example, row 148 has some data and the next set of data is in row 164 and 165. I have copied and pasted that info into the Data Extract worksheet as I would like it. If possible, I would like to exclude the rows with totals from dumping onto the DATA EXTRACT worksheet.

The purpose of the macro is to save me the time of looking at every single row and coping and pasting information into the data extract worksheet. There are over 700 rows and there's over 50 of these worksheets.

Any help would be highly appreciated.

Cheers!