VBA to copy certain cell from certain worksheet to master worksheet

[Yokus]

Hello again.
I need a VBA code that can copy/combine certain cell values from certain worksheets into 1 worksheet. I have been searching the internet & found a good code that I have tried to tweak to fit my situation but have had only limited luck. My workbook is a shared workbook that is updated on a daily basis.
What I need the code to do is copy the occupied cell content from each worksheet starting at cell C3 and paste it into the master worksheet starting in cell A3. Data is added to each sheet on a daily basis and each sheet will have a different amount of data on it (one sheet might have 27 rows of content and another 15). I don't know if there is a way to copy/paste the conditional formatting also, if not, then that is not a big deal.
I have attached a copy of a very condensed version of the worksheet with only a small amount of data on it. I also have a tab that shows the original code that I am trying to use. I have updated the names of the worksheets in the code but I have left all the other code as it was.
Can you please look at the code and tell me what needs to be changed to accomplish this task?

Thanking you in advance!!

[dflak]

A couple of things: you have Excel 2016 which means you have tables. This means that you don't have to have a thousand rows filled with formulas for rows with no data. One of the advantages of tables is that they copy down formulas, validations and formats automatically. So when you add data to a row immediately below the table, it becomes part of the table, and it inherits everything from the row above. You an even remove all the data from a table and it will still "remember" the formulas, formats and validations when you paste new data in.

Here is more information on tables: http://www.utteraccess.com/wiki/Tables_in_Excel.

Here is an assumption I will make: you will be adding data to people's sheets each day. You don't want to be copying the old data over and over again winding up with duplicate data.

I also assume that you have more than just two people, so I'll have to give you a place to enter the list of sheets you want to copy.

[dflak]

Here is my shot at it using tables.

I notice that you have several formulas that are "broken" they have broken references. I do not know what these were supposed to look up. I suggest you fix these references, then make a copy of one of the people's sheets and clear out the data. Save this sheet as a template. Then for new people. make a copy of it. You can copy and paste data into it, but you may have to re-establish the formulas. If you copy over a formula, then the cells get the new formula.

Once established as data is added row by row, then the formulas and formats will copy down.

I tried to preserve the conditional formatting in the copy, but since we've shifted rows, that did not work out. I suggest that you set up the conditional formatting in the table in the master sheet. As the program copies data in, the format will be applied to the whole table.

[Yokus]

Thank you, dflak, for your response. However the workbook will be a shared workbook so I cannot use a table. Believe me, I would much rather be able to use a table.
The broken references are because I had to delete several reference sheets because they contained too much data and made the file too large to upload to this site.
Do you have suggestions for the VBA code?

[dflak]

Shared workbooks cannot contain macros. I did not know that they could not contain Excel Tables too.

If you want concurrent access to data, then you need a database. You can build an application in MS-Access (paid license required) and distribute it to the users (free download from Microsoft available - they can do data entry and run reports - they cannot do development). Then you can use MS-Query to pull in the data and analyze and display in Excel.

Technologically, it's a relatively easy system to implement and offers a lot of benefits. If you can sell such a solution to your management, you will have a very powerful and flexible system.