Trying to write a program that will copy cells V1, AB3, AB4 AB5 and AF4 from a worksheet and paste them in single row in a master table, then repeat the process on the next worksheet and put the data in the next row of the master table, all sheets are in one workbook.

The range of worksheets I want to copy from will be extended indefinitely, but they come from a template so the info I want will always be in the same cells.

The workbook also has a coversheet as well as a number of other charts etc that I don't want to copy these cells from, but these won't be added to or changed, so ideally I trying to write some kind of loop function that can go through the whole workbook, but ignore some sheets that I am able to name in the code.

Cheers