Moving contents to another tab (easy?)

hello

I have data on one tab in a workbook titled "1804", on this tab I have a ton rows that in column "B" have the contents "RM". I need specific data for each row moved to another tab in the workbook titled "RM". On the RM tab I need the following cells content moved from the "1804" tab:

column C contents, moved to column A (starts at cell A2) on "RM" tab

column K contents, moved to column B on "RM" tab

column M contents, moved to column C on "RM" tab

Column N contents, moved to column D on "RM" tab


Possible to paste the folumula on the RM tab and drag down to account for all the "RM" rows on the 1804 tab?

1804.png


RM_tab.png

thanks, are you able to help with the filter/choosecols?

attached excel doc

That worked, however, can we max out the rows to like 70 or so (when referencing the 1804 tab)? 38 rows was used in the example, but its possible more could be added in. I tried editing the formula but got some errors

Also, quick question. When I delete the data from the 1804 tab, and paste in a new data set (all in the same format and row counts) I get "REF#" errors in the formula on the RM tab for where the row numbers would be. is there any way to lock in the formulas cells on the RM tab as I remove and paste new data in the 1804 tab?