Repeat a formula 5 times before changing cell reference

Attached is the file. On the TE Details Tab starting in A4 is where I need it to repeat 5 rows. ANO through XCL in column B. Then you will see ANO through XCL repeat over and over down column B. The codes I need populated in column A are from the running list tab column W but I want the formula to skip any value in column W on the running list tab that is labeled Duplicate or Added so that I just get the rates that I need loaded into our software.