Any and all help will be appreciated profusely. I can usually make small modifications to a code but I'm in over my head here.

I have multiple workbooks that are essentially data surveys that are submitted monthly. I need to put together a spreadsheet in table form so that I can do some annual analysis. I have found the following code and have it working to read my data files, but it creates the new summary sheet with the same format as the surveys. I'm not sure what to change in order to print all of the values from each worksheet on one single row.

As an example, I'm getting this

1234
5678

1234
5678

And I want:

12345678
12345678



Please Login or Register  to view this content.