I would like to run a macro that completes the following tasks:
Copy the first row of worksheet named 'DataSource' and ...
insert that row into all other worksheets of the active workbook, placing it at the very top of the respective worksheets without overwriting the existing first row but pushing that row one row below.
Help is much appreciated. Thank you very much in advance.