hello everyone

I am looking for a vba code that willl help me collate data from multiple workbooks into one master workbook.
The range to be copied from all the workbooks will be same. range a18:f18