Excel macro needed

[dhitchco]

This should be a pretty straigh-forward Excel macro that we're looking for; anybody have such a beast?

Two spreadsheet (workbooks)
Workbook A has one spreadsheet with a separate row for each match/team being scouted. Each row has multiple fields (columns).

Workbook B contains multiple tabs for each team

namely, we want to copy each row from workbook A into the respective "tab" in workbook B into a new row on that spreadsheet tab. If the row in workbook A doesn't correspond to a current tab in workbook B, then create a new tabbed sheet in the master workbook.

I've googled-around for Excel Visual basic macros but can't find this simple cut & paste routine.

Yes, i think the other way to do this is to simply dump all the scouting records into one huge flat spreadsheet and then use the "sort" and "subtotal" functions to group all the records by team number.

Thanks if anyone has this info.....