Excel VBA，使用数组加速代码

thanks in advance for any help on this, I have a big spreadsheet I need to parse into other spreadsheets, and I have something working, albeit slowly. I've read that using arrays is a better approach, but I can't seem to get it working, I think I can pull the main spreadsheet into an array, but I can't operate on it like I want. Specifically, I can't grab certain rows from the main array and insert them into another array to copy into a target sheet at the end. Here are the original, working functions:thanks in advance for any help on this, I have