populate multiple sheets based on a criteria

hello All:

I am a newbie to VBA ...and am struggling to make the following happen...

I have the following data in an "input" worksheet...I want to run a macro that scans the "tag" column and then sends the corresponding information in col 1 col 2 and col 3 to a worksheet called "file1" or "file2" depending on the result of the scan....basically i want to populate sheets file1 and file2 with data that is relevant only to file1 and file2 respectively from the input sheet....hope i make sense....

i have attached the excel file along with what I expect the macro to do with the data on the input sheet if all is well...

thanks all for your help!

Welcome to the forum

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.