Macro to copy specific cell if match critera

I am looking for a way to copy/paste information from the third column of the name range to a different sheet based on a key word in the second column (columns in the name range are E:G). The information needs to be paste in a different sheet starting in B6. 2 of the columns could have the same key word but I need it to ignore the first column in the name range.

Current Code that grabs everything that has "Rotating" in a cell. (found it online in the process trying to make it work for me)

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

I took another look at it and it could be shortened to this

Please Login or Register  to view this content.