I have 186 workbooks that each have single sheets all in the same format,
what I would like to do is combine the workbooks into one, It can either be
in a single sheet or multiple sheets. I would like to name each sheet with
the value in A1.

Any help will be really appreciated