combine worksheets

I have multiple workbooks and want to consolidate them into one, maintaining the individual worksheets. There are ~2-5 sheets in each workbook depending on reports received. Each tab (worsksheet) is unique in name. I can easily do this by opening each workbook but I'd like to do this for...

Hi, I have been frantically trying different methods and searching for help for a while to complete this, but unable to find a solution that allows you to combine sheets if column headers do not remain constant. I need a macro that will produce a summary sheet combining an initial despatch log...

Hello Excel Experts: I have search this forum before i made a new post since none of the threads is exactly working for my problem. I have an excel file which contains costed bills of materials (BOM) of products, each worksheet is named by its SKU/model number. My data has consistent/fixed...

Hello, I have been stuck on this project for weeks. There are six sheets. One named 'Macro' that will have instructions and command buttons, 'Results' where the data would populate, and APAR, MBS, Purchase, and Sales. So the common identifier is the CUSIP. Not all sheets will have the same...

I have been looking around websites and forums for a solution to combining all open workbooks into single worksheets and really struggling here as I'm completely new to VB. I found the following code that combines all open workbooks sheet1 into one workbook as separate tabs which is great but...

Hello all I have been new to VBA and have been working in it for about 2 weeks. I am trying to aggregate a data set from a folder with multiple workbooks into a single workbook. The code bellow does that but I also want to delete the copied workbook after it is placed in the "Master workbook"...

Hi All, I have a one workbook with multiple sheets. And I wanted to combine these sheets into one sheet except for worksheets with sheet name "summary" and "data". My code is not working because it is still combining all the sheets even if the worksheets "summary" and "data" are hidden. Can...

I have three worksheets, created by three different organizations. The organizations update these worksheets multiple times a day and do not want to combine them, because that would mean 50+ users attempting to access one worksheet to log their changes. I need to have one "master" worksheet that...

I am trying to figure out how to combine 2 macros. The first macro allows me to select the file path I need, and the second macro will use the file path from the first macro and pull the worksheets from all files in the file path and combine them into 1 summary workbook. What is the best way to...