Okay, I know zero VBA (but small amounts of other languages) and after browsing through a bunch of find/copy/paste code, I think my situation is unique enough to require its own question. Not sure if this is possible, but I would like a function that:

Takes a value from a cell (say A1) in sheet 1.
Finds any occurrences of that value in sheet 2, column 1,
Cuts (or copies then deletes) that entire row,
and pastes it into sheet 8.
Then -
Loop, except use value from sheet 1, cell A2 for the search, and when pasting into sheet 8, use a new line, don't erase what's already there.
Loop until I hit specified row in sheet 1, or the end of the data, whatever.

Any chance? It would be even better if I could search sheets 2 through 7 instead of just 2.

Thanks for reading!