@Abhiram I fear you still need to be more precise. On which sheet of the “Common_file.xlsx” are the values supposed to appear?
“2020 doc” or “Tracker”?
In my example I assumed “Tracker” since there already was data there but the structure would not match the data from the “work_example.xlsx” file although I narrowed it down to just the columns that were there.
What happens if there are still cells with information there. How would the rows match?
For more complicated operations you might have to use python: