Need help with sorting and copying from multiple worksheets

I need to copy a report from several sheets,
Workbook 1
First i Have a report Sheet with a fixed header in the first several rows
A Sequence of Operations sheet
Work book 2
A raw data workbook for the values, CSV
The raw data are arranged in the same column arrangement as the report sheet
I need a way to import the raw data from their worksheet into the worksheet where the report sheet is, without deleting the headers also importing the sequence of operations and sorting them by date " the first column, the first row after the header"

After being done i need to copy that report into another sheet where everything is similar but the column are of different arrangement eg: copying A into C and B into F . Also with a set header which is not to be affected