I’m trying to create a simple loop for below code:

I’m trying to create a simple loop for below code:

this might not be the right way to go about this, but I have a workbook that is running between a couple of programs pulling data and formatting it. One of the things I can’t get past is that one of the programs is feeding in a few lines of data that I don’t want. Unfortunately I don’t know that program (Rocket Terminal / Also known as Attachmate Xtreme) well enough to stop the data.

I am struggling to get a code to loop through a set numbers of worksheets (sheets 10 to 16) for the second sub in the code.

I’m preparing macro that copy and paste between sheets and data ranges. Also it’s deleting unwanted data.
Workflow is:

I have code that works to pdf each worksheet as a separate pdf, but I want to add another worksheet each time, as the cover sheet. I cannot find a way to dynamically change the array to keep one sheet constant whilst looping through the other worksheets for the other sheet.

The question is exactly as described in the header, but I will give an overview of what the code is intended to do for better context as it is a chunky bit of code.

I want to filter and split the data based on branch name (Branch List sheet), and also want to save that new excel workbook for each branch as per the same name as mentioned in the Branch List sheet. Please help me with LOOP function to complete my code.

Tried running a for next loop and it resulted in more values than the value range divided by the step count.

Please help me out with LOOP function, as I want to save data in new excel file for every branch based on branch name (Branch_List) sheet. Need to split data & save file based on Branch list. below is the my code with 2 branch name. Attaching the branch name list for your referance.