Write a VBA script: copy format between Excel files

I regularly create tables in a statistical software and often export them as Microsoft Excel files to share them with my colleagues. Due to modification on the upstream analysis, I sometimes need to export Excel files with virtually identical formats, but different values. The problem is that I need to MANUALLY format the Excel file every time I export tables, hence this project. I am seeking someone who can write a VBA script which accomplishes the following: 1. On a GUI, asks existing Excel file A, a worksheet in it X, and a worksheet Y in the Excel file in which the VBA resides. 2. Reads the format of worksheet X. 3. Applies the above format to worksheet Y. I assume loading the VBA script, saved as a .vb file, using Microsoft Visual Basic for Applications executed from Excel's "Development" tab - "Visual Basic". I do understand that an alternative can be to create a single executable file from the VBA, but I prefer running a .vb file for possible future modifications. The Excel files have the following constraints. It will be OK as long as the VBA script works within these. 1. The first row contains column names. Every column has a column name. No blank. 2. The second and lower rows all contain data. Characters or numbers. Data can be blank (missing values). 3. Formatting options that I regularly use are: - Column width - Cell Format - Conditional formatting - Scroll lock - Page layout - Sort However, copying ALL the formatting options is the requirement of this project. Please let me know in advance if you believe it makes sense to restrict the type of formatting options to copy for fast execution, etc. 4. The file does NOT contain: hyperlinks, pivot tables, graphs, diagrams, pictures, comments, form controls, scripts. Columns must be matched using the value of the first row. This is because I sometimes add or delete columns in the statistical software. Failure to match renamed columns is OK. Please forgive me when there is any incorrect wording of Excel's features here.