Paste clipboard contents

I have an application at work that generates a report in the form of a table. I can view the table then select "Save to Excel". If I select this option then open an Excel workbook and paste, the entire table is pasted in an unformatted form from the active cell. I then filter, format and save various filtered results to different new workbooks. This is the process I am trying to automate using VBA.

What VBA function would paste the clipboard contents starting at a particular cell? In effect Ctrl-v. I've seen a number of examples but they don't quite match what I'm doing as Excel won't even be opened until after the data has been copied to what I'm guessing is some sort of global clipboard by the other application.

Once I've worked this out I will research how to filter the spreadsheet, create new workbooks with file names and paths I construct and paste filtered results to these various newly created workbooks.