Quick VBA Macro required for a spreadsheet

Job ID: 31622456

Budget: $10 – $30 USD

Got a quick job here

I have a spreadsheet with 6 columns of data, which needs to be carried over to another sheet based on the Report ID

Although not entirely required it would be great if a macro could save the report in a folder as seperate document