Combining multiple single sheet workbooks into one large workbook (1 Viewer)

[JRT]

I have 20+ individual workbooks that all contain one worksheet a piece.

I need to copy the data and formatting from those individual workbooks into 20+ seperate tabs in a single workbook.

Both the file names and the resulting tabs can be static in naming convention.

I tried to use access to pull/push the info, but the formatting is critical.

Any advice is greatly appreciated.

I'm comfortable writing basic VBA code in Access, but have not done any 'coding' in excel.

Dave

 

[Call_Me_Sam]

I have 20+ individual workbooks that all contain one worksheet a piece.

I need to copy the data and formatting from those individual workbooks into 20+ seperate tabs in a single workbook.

Both the file names and the resulting tabs can be static in naming convention.

I tried to use access to pull/push the info, but the formatting is critical.

Any advice is greatly appreciated.

I'm comfortable writing basic VBA code in Access, but have not done any 'coding' in excel.

Dave

Dave, i do hope you managed to solve this even by simply right clicking each sheet and selecting Copy to the 1 big workbook. Would that have been the too easy solution? and no code involved...