Macro help with loops and auto stop

[RaElla1]

I need help writing a macro to copy a select number of rows on the "Pages" worksheet and update links for these rows by referencing a list on the "Line Items" worksheet. The loop needs to continue copying & pasting rows (with formatting) until there is no more data in reference list.

Let me know if you need anything else.

Blessings