Macro to copy data from multiple worksheet cells in to a single Master worksheet

Hello! I searched the forums and found things similar to what I need, but nothing specifically and these posts were 3-10 years old and no one was responding to them so I thought I would ask on a new post...

I have a workbook with several worksheets (will be adding and removing worksheets often) all formatted the same. The worksheets are set up like a form and have key data in the same specific cells in each worksheet; C4, C5, G4, G5, K4, K5, and L32 etc. (there are more but just as an example)


1. I am looking for a macro that will go through the workbook and grab the data from almost every worksheet and compile (copy) it in a worksheet called "Master" starting in row 2 (as headers will be in row 1).
2. I need it so every time I run the macro (I will put a refresh button in), it deletes all of the current data in "Master" (from row 2 and down) and then updates it with the new data from each worksheet.
3. I am trying to find a way that when it compiles the data in to "Master" it will also add in the name of the worksheet (in column A) where that data came from, so I have a understanding of which worksheet it is/was from.
4. Besides the "Master" worksheet, I have a worksheet called "Summary" that I am will be using a drop down list and simple vlookup against all the data compiled in "Master" so I can select the defined name/range and then get the values based off the vlookup (I know how to do this part). In short the macro can't run on the "Summary" or "Master" worksheets, but all the others in the workbook.

Also, I am using Excel 2010 on windows 7

for this example, I am basically looking the macro to pull the data from these cell: C4, C5, G4, G5, K4, K5, and L32


Thanks in advance

Sand box2.xlsm - sample book with worksheets and "Master" as it would be after a Macro was ran