You'll want to COPY VALUES ONLY from cells K4167:Z4167 each time it changes.

Then PASTE SPECIAL VALUES to the first empty in a blank worksheet. Paste to A1 to begin with ... the code will do the rest.

When ready, you'll have a table of data to view.

Google for examples for the terms in bold. Tons of examples to review.