Hi,

I've never used VBA and have been trying to figure out how to write the code I need for a few hours now.... so I'm really hoping someone is able to help

I have an excel workbook with several different tabs. I want to create a summary sheet with certain column headers. These column headers are already on the majority of the other tabs (all except my other summary tab) and I want a macro that will pull anything under those columns on those tabs without the column headers. I also want it to stop once pulling from each tab once it goes blank.

So far, I have the summary sheet labeled "Sales Pipeline" and I have the 4 columns that I want filled in across the top (A1-D1). I want the macro to search each tab for these column headings and then copy over any data beneath them. On each of the tabs that have these columns, the headers are in cells I5:L5. Does this make sense? Can someone please help??