Merging Worksheets

sniderrn03

New Member
Joined
Aug 25, 2011
Messages
12
Hello,
I am extremely new to macros/VBA in excel. I have been reading through the threads, however, am having difficulty changing the current macros shown to what I need. I am sure this is due to my inexperience.
I have a workbook with 8 worksheets. The first 6 worksheets are going to have 14 columns (Date of entry; Priority/Severity; Provider Name; NPI; Member Name; Member ID; PA Number; Issue 1; Issues 2(optional); Issue 3 (optional); disposition of PA; Additional Information; Reported by). The 7th and 8th worksheets have other information, however, I do not want to merge these worksheets.
My goal is to merge worksheets 1-5 into worksheet 6 that is labeled: All Current and Entered. I would like worksheet 6 to auto update as changes or new rows are added to worksheets 1-5.

Any help would be greatly appreciated.
Thank you,
Sniderrn03
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

sniderrn03

New Member
Joined
Aug 25, 2011
Messages
12
Thank you for the link. I had read through this link from other questions I had found in he forum, however, the code that this link shows is not providing what I need for this particular file. It first gives me an error on the LastRow code and according to the instructions, it is just going to add a new worksheet, which is not what I am looking for at this point. I have a current master worksheet 6 with some data that was manually copied in, however, I obviously am trying to avoid the manual cut and paste as others update their individual worksheets 1 - 5. I also don't see how the code listed in the link provides automatic updating from the worksheets 1 - 5 when new rows are added.
Thank you,
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,487
Messages
5,831,981
Members
430,100
Latest member
namhnz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top