Combine all sheets into one

Excel - I received assistance on some code that updates a master sheet based on several other sheets.  
I would like to be able to use different workbooks instead of different tabs.
Example: Have 4 or 5 work books that update a Master file. The master file would contain the Change log
CombineIntoOne.xlsm
ssblueAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Are all the files in one folder?
ssblueAuthor Commented:
yes
Roy CoxGroup Finance ManagerCommented:
Is the e\ample attached based on a master workbook. That is, will the other workbooks be the same layout  - sheets for various people and a change log. Each sheet will then be imported to the master workbook and added to the relevant sheet there.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ssblueAuthor Commented:
Yes, all sheets will be laid out the same and reside in the same folder with the Master showing the latest revision.
Roy CoxGroup Finance ManagerCommented:
I'll have a look at adapting some code for you.
ssblueAuthor Commented:
Thanks!!
Roy CoxGroup Finance ManagerCommented:
I haven't tested this so it might need some tweaking. Check it out on sme dummy workbooks and let me know. I'll be around tomorrow if you need changes
CombineIntoOne.xlsm
Professor JMicrosoft Excel ExpertCommented:
Hi ssblue

you can use http://www.rondebruin.nl/win/addins/rdbmerge.htm    Free Excel add-in RDBMerge

rdbmerge.png
ssblueAuthor Commented:
Professor J, thanks for the info however I can't use an Excel add-in at work. :(

Roy, I'm not sure I explained this correctly.  The example I posted works fine. Each tab is updated to the Master tab.  However what I would like to do Is have Five (or more) separate files. One for each person and One Master file. All files would reside in the same location. Each person would open their file to work on and the Master file would automatically be updated.
The file you posted seems to me similar to the original one I posted, If I am missing something here please let me know. Sorry for the confusion.
Roy CoxGroup Finance ManagerCommented:
I think you would need to have some code in the before close event of each workbook. However, I think the best way would be to have one workbook, but access to individual sheets limited by a password for each user. Unless  they need access at the same time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ssblueAuthor Commented:
That's what I was afraid of. What we have now is working but I was hoping for something that might eliminate some confusion for the users. Sometime they click on the wrong tab. : (
Thanks for the help and advice. I think I will close this question if no one objects.
ssblueAuthor Commented:
Both offered insight and helpful suggestions but nothing that would work in my setting.
Roy CoxGroup Finance ManagerCommented:
How do they click on the wrong tab? Surely they have one tab in their own workbook.

Also, the problem I see is how do you only import/export new items, are existing items deleted after saving?
ssblueAuthor Commented:
So there is one workbook with 5 tabs, Master tab and tabs with their names. They will click on someone else's tab for whatever reason - I don't know .
Each sheet is exactly alike with all the information needed except for the columns where updates are to be made. So each person is responsible for their own rows based some of the information in the sheet. No new rows should be added once the updates begin. If there is a need for some new rows to be added then they are added to all the sheets.
Roy CoxGroup Finance ManagerCommented:
I have a userform that requires the user to enter their name and password to access their worksheet. Take a look, if it helps I can add it to your workbook
PASSWORD-FORM-7.xlsm
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.