Excel VBA Macro to process data - speed is very important

General information for the business: We process data
Description of excel work: Hi there

I need a macro that pastes data copied from the web into a spreadsheet, and then orders the data.

The format of the data when pasted is not consistently distributed so there will be a number of rules needed to format the data as required.

The information will already have been copied from the web so the first action is just to paste - there is no need to fetch the information from the internet.

Thanks
Extra notes: