Createx Workbook

I am trying to merge (1) sheet from several workbooks (each have several worksheets) into 1 worksheet. They are all in the same folder. The name of the sheet is strlist. Here is what I am trying, but

Createx Workbook 1

Excel 365 Transferring Page Layout (mainly headers/footers with text formatting, margins) from one workbook to another? (w/o VBA nor Add-In)

Createx Workbook 2

As you can see on the attached screenshot, my excel shows an upsidedown column until 49th one, when I open the excel workbook. It sometimes appears in my saved excel files, but usually, it fixes when

Createx Workbook 3

WorkBook Software A/S was founded in 2001 and is a leader in economics and project management systems for advertising firms and communications agencies. Their product is a software suite for project ...

Createx Workbook 4