Copy Entire Row from Main Sheet to New Multi-Worksheets if Cell Contains Specific Text?

I've researched this here on the Forum but have been unable to see anything specific to what I'm trying to accomplish. I'm not familiar with writing code or macros and from what I've read so far, this can't be done with formulas. I'm a 70 yr. old beginner geek that needs some help. If someone could see what I need and write the code for me, I'd be very grateful. I know it's quite a challenge. I will include a screenshot of my main sheet that is the "Source". The tabs at the bottom of the workbook are my "Targets".

Brief Description: This is a record keeping spreadsheet for members of a Forum that I admin. It is for tracking owners of 7 brands of RV's (recreational vehicles). I input all data for 1100 members (Rows) so far, across 42 columns. Each member would need to be identified by the brand of RV he or she owns. That would be column "N" which is the "Map Pin Column". I pin each members location on a Google Map using different color map pins for each brand of RV ("c" = Carriage, "l_blue" = Lifestyle, "orange_stars" = Alfa-Gold, "pink_stars" = Bay Hill, "wht_stars" = Bay View, "ylw_stars" = Tesla, "grn_stars" = Other). So all members with a "c" would go to the Carriage tab/worksheet, all members with a "l_blue" would go to the Lifestyle tab/worksheet, etc. etc. I would need each new entry to go to the next available blank row on its tab/worksheet. I'm hoping once its there, the sheet can be "sorted" manually by their Username (column "E"). For 4 years I've been doing a lot of time consuming copying & pasting and would like to make the data processing a little easier.

Any and All help is very much appreciated.

Attachment 500457

It could be done with a few formulae - are you dead set on a VBA solution?

When I tried to download your attachment I got a message that it was invalid, and it would help if you attached a sample Excel workbook anyway, rather than a screenshot.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon does not work.

Hope this helps.

Pete

Pete, Thank you for your quick reply and your willingness to help. After my original post I started reading old posts again and I stumbled onto one of you replies where you helped someone else with a simular request. I was able to alter your Formula to make it work for me. Again, thank you. I will now mark this thread as "Resolved".

Glad to hear it - thanks for feeding back.

Pete