Pull databy sheet name

[mcommon1]

Hi Ya'll,

Looking for a way to copy a row of data into a sheet based on its sheet name.

Thus any time 'Soccer' shows up in Column A, it would transfer over the entire row of data to the sheet named 'Soccer', but only those rows with 'Soccer' in column A.

Thanks and regards,
Mark

 

[mcommon1]

Oh and I can either push or pull data, it doesn't matter!