merging sheets

I have a workbook that has 5 similar Sheets worth of data in columns A:U. Is there a way to create one giant database out of the 5 using VBA? Little out of my element and macro recording ability. Thank you

I am spending way too much time combining worksheets onto a summary sheet. Is there vba code that could do this for me? I must combine worksheets together that have "REQ" somewhere in the tab name within the active workbook which could be one tab or several. My only worry here is the author of...

Hi Guys, I'm seeking some assistance in trying to merge several sheets in a workbook. The problem i'm experiencing is that because the workbook is shared and protected, I do not have the ability to utilize VBA. I also tried to use the add on Kutools. Not sure if you have heard of it, but...

At work, I am able to download a mailing list from our database, but it always comes out as a pdf. When converting the pdf to Excel, it makes a new worksheet for each page of the pdf. This sometimes results in an Excel workbook with 300+ worksheet tabs at the bottom, each with 50 rows. They...

Hello, So I have 2 sheets in my workbook. Sheet 1 has Names, ID numbers, and Managers. (about 500 rows) Sheet 2 has Names, ID numbers, Program, Program Numbers, Total Hours. (about 40,000 rows) I need help using the unique ID numbers to merge the data into one sheet with ID Number, Name...

I have two workbooks, both of them contain sheets with the same names, the workbooks are created by a macro. The Macro is basically formatting the sheet, it takes a CSV file (generated from a website) saves it and formats it, applying some auto filtering, and moving some of the data onto other...