Loop through a folder copy and paste range to 1 workbook

I need a copy to loop through all files (.xls) in a folder then copy a range ("B11:P" & lastrow) and paste to 1 sheet.

Goal is to compile all data in one Masterfile.

The files in the folder will have the same format and tab names. I need the data from the tab/sheet named "Input"

I currently unable to sensitise the sample data and unable to find a code in my research to get me started. any input will help so thank you in advance

You did not specify a path or directory name, so it is assumed that the Master workbook will be in the same folder as the files and the Master workbook will host the code.

Please Login or Register  to view this content.

Thank you JLGWhiz!
How do i paste as value only not copying the formula?

change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Thank you!