VBA Code to consolidate same column headings from certain tabs

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??

Yes, of course - silly me. Thanks for helping!! You have no idea how many times I've tried this.

Yes, that would be great if it could pull in the employee name from the name in cell D1. Yes, please feel free to put data in! The difficulty is that sometimes there will be data filled in in those columns and sometimes there won't (sometimes there will be multiple sales pursuits filled in and others may have zero). So I want to build the macro saying if there's no data to pull into the summary tab to go to the next worksheet with those column headers.

No not for all tabs which is part of the difficulty I was having. There are a few hidden tabs that I can move to the front of the spreadsheet so then it can look up the sheets after the "sales pipeline summary" tab if that's easier to do?

Thanks so much! It will be refreshed weekly and will need to update with new results (and not repeat items that are already there). Would I have to try to write code to create a new spreadsheet and delete the previous one out in order to do that? I might be able to figure that out but the person who will be refreshing this every week won't know how to do it unless it automatically updates or there's a button to press. Can it just automatically update every time the worksheet is opened? Will there be any issues if it's stored on a sharepoint site?

Sorry if I'm not being clear - I'm not good with the lingo yet and how this all works. thanks again for your help.

So what is going to happen with the workbook is each tab is going to be updated by a different employee each week for their current sales pursuits. Then once a week, the leader of the group has requested to see a summary of what's on the tabs (rather than flipping through all of them). So if there are changes to the data within the relevant columns on the individual worksheets, I would need it to automatically update for those changes. I think if it erased the old data and updated with whatever would be currently listed on each tab, that would work. Does that make sense/?

Hi, I made a change to the code so that it will create a new worksheet with updated data every time it is run. I can't figure out how to make the macro run though each time data is updated/changed/inputted in each of the worksheets. Can someone help with this?