I need to create a formula or a Macro that compares data on one worksheet and
it compares it to another worksheet and if it finds a match moves it to a new
worksheet. I tried using the index and match functions but neither seem to
working very well for me. Can anyone help give me an example?

Thank you