Find And Copy Between Sheets Using Function

The project is to take an unsorted list from the first worksheet in a workbook, and based on the value in column A, copy the row data to other worksheets. It's just a straight copy of nine columns of data, and could either include or exclude that first column. (Since that value will always be the same on every row, there's no real need to include it except as a quick visual affirmation of which worksheet is being viewed.) The number of rows of data in the first worksheet are unknown, so the range is not fixed; and the number of expected matches are unknown.

I've found all kinds of advice about using a macro (but I can't use a macro, because the workbook will be maintained by someone who has no VB training), or if they do refer to formulas, say nothing more than "use VLOOKUP, or OFFSET and MATCH".

All the Excel Help file and online references I can find only show how to use VLOOKUP to copy data from a single column, as the purpose and design of that function. How is it possible to use VLOOKUP to copy the row of data?

And to copy into a new row for each match?

I can't even find information on whether that function is entered once for each worksheet or whether it has to be copied into each row.