Need a master worksheet to populate based on other worksheets

For accurate and timely response, always attach a sample workbook so others can see the format.
Also, be clear in your request / description of issue. You said that when a user enters information you want the totals to be copied on the last page in next available row. Does that mean every time a user updates information a new row is created for that user or does the existing row for that user get updated?
A sample file with non-sensitive data will go a long way in getting a fast resolution.
modytrane

Thank you for your response.

A new row is created each time a user updates his/her worksheet. I would want this information to then carry over to the Totals page.

I have attached a copy an example. As you will seeon Ryan's worksheet client ABC and on Liz's CDE, yet both are on the Total page.

hi, slasch, how about the code that you will run whenever you need and it will collect the data from all the sheets on Totals sheet? To my view that will be better option for your task.

please check attachment, run code "test"

If the data on TOTALS sheet should be cleared before collecting data from the sheets, uncomment (delete ' at the start of the line) this line:

Please Login or Register  to view this content.

At the moment the data from sheets will be copied to TOTALS sheet as many times as you run the code

Thank you so much! That works great. That makes it easier.

if you are happy with the solution provided, please mark the thread as Solved, see Forum Rules for details: http://www.excelforum.com/forum-rule...rum-rules.html, rule #9