I'm making an employee daily progress report that shows what they accomplished for the day. I get the data I need from a software we use and then create a report and copy and paste that report into excel.(There is no export to excel option) I copy and paste the data in spreadsheet2 and would like the data to automatically go into spreadsheet1(which is already formatted to a report style spreadsheet). Here is the tricky part the info I past into Spreadsheet2 won't have the same format as spreadsheet1, so what i need is a formula that can recognize spreadsheet2 Row and the Column names and be able to transfer those cell values into the correct Row and Column names in spreadsheet1.

For Example:

Spreadsheet1 will have the employees name in column A2-A13 and the Columns would be across cells B1-F1 each having its own specific title

Spreadsheet2 employees name will also be in column A2-A13 but wont be in the same order as spreadsheet1 and the order will change everyday, this is also the same case for columns.

I'm not even sure if this is possible to do in excel, I thought i could create a "IF()" formula that would be able to send spreadsheet2 cell values to the correct spreadsheet1 cell based on which column and row it was located under but I have been unsuccessful so far. Any help would be awesome.

Thanks,