Excel crashes when macro is run, but individual portions of macro function when stepped

So I have a lot of data from a machine in the lab that needs to be parsed and made accessible for me, so I designed a macro to do this in a manner that is expandable in terms of every thing I may want to expand about it. Basically I designed the macro in the individual steps tested each, then combined them. Each individual step functions, but when I try to run the macro as a whole excel CTDs... Obviously this is not at all helpful. I assume it's because I'm asking it to do a lot, and this is especially concerning as the data sets will likely only get larger with more parameters to cycle through. Is there any way to make it take a break every once in a while or something to make it actually function. I've attached an example data table that I've been using to construct the macro with as well as the macro and the crash error files separately in case the don't properly save in the table. I tried to comment things decently so others can have an idea or what I'm trying to do. Any help would be appreciated thanks.

I should add when I put strategic breaks in the testing thing, it seems to break at the area near the end beginning with:

'Establishes values of each
For r = 2 To max_row