consolidate multiple worksheets into different workbook summary worksheet

[FROGGER24]

Currently going through an audit and need to consolidate multiple worksheets into another workbook called Audit onto worksheet named "Summary" All the worksheets are formated the same and the data range is from A2: O to last used row in column A. The destination will be to workbook called "audit" and first blank cell on worksheet called "Summary". Will need a workbook loop to run code on each workbook in the directory copying worksheets to the Audit workbook.


Thanks for any assistance