I have numerous blocks of data in 2 columns and 8 rows, and within each block I need to do repeated V-lookups to arrange the data in a different order on 4 separate spreadsheets (other workbooks). The columns are absolute (A & B), but I am constantly adding new rows in blocks of 8. Using a relative reference on the rows only adjusts them by one row. Is there a way to get them to adjust by 8 rows?

Each cell in the first column contains 3 letters of text that are unique within each block, but repeat again in each new block, although the order varies based on the corresponding numeric value in column B (in descending order).

I don't know if there is a formula for that, or a way to assign range names automatically, or set up tables or arrays, or some kind of macro to do this? The new data comes in by date, so I would consider using a third column with dates to trigger a new range name. (There is daily data on one sheet, weekly data on one sheet, monthly data on one sheet, etc. so even the dates will be tricky to use as range names since some data will overlap.)

I would like to automate this process as much as possible. Suggestions would be greatly appreciated!

Stevie the Kid