I need a custom macro written

I need a custom macro written to eliminate certain data from 2 sheets then compare them. This is for comparing billing vs actual use. We are a trucking company that handles intermodal freight. For our trailer billing the company we use bills by the day however their invoicing is often incorrect and takes time to compare. EX. container abcd1234567 we hauled from 1/1/23-1/3/23. The trailer company charges us from 1/1/23-1/5/23 in error. I need the macro to find the reference number on both sheets (abcd1234567) then compare the dates and call out errors.