I am just beginning to learn how to implement loops, so bare with me here in the thread.
I have a dynamic range on Sheet 1 that uses the following offset formula to return a range from A2--that's where the records actually start--and the last used row in the column. For the purposes of this thread, I'll call it "MyRange".
In Sheet 2, I have a form that is intended to loop through "MyRange", and plug each cell in "MyRange", one-by-one, into Sheet 2, Cell A1.
After it drops that name, the form will gather the rest of that respective entry's data from Sheet 1.
Here is the code I was working with: