I want a vba code which can perform the following:
1. Copy the data from a range in a sheet (to be named) from a excel file in the folder on to a new sheet. The column A will include the name of the file from which the data has been sourced.
2. The vba will append the data (one below the earlier) from the various sheets in the folder.