Merge data from multiple spreadsheets into one master sheet.

Hi,

I’m after some assistance creating the correct VBA to do the following:

• There will be several workbooks stored in the same location (with different filenames but they should start with ‘Chase updates’) C:\Users\SmithJ\Documents\Spreadsheets
• In these workbooks is a sheet called. ‘Chases’ all workbooks in the folder and the master sheet have the same format.
• I want to copy the data from the chase spreadsheets the data I want to copy will start in Cell B14 and got across to cell I14 but the amount of rows of data will vary from sheet to sheet.
• Once copied I want the data entered into the master spreadsheet ’Chase updates for WC’ on the ‘Totals’ sheet. Again the data would be pasted into the same location as it was pasted from B14 toI14 down, the data would need to merge all the data from the spreadsheets into this master sheet rather than copying over the data each time.

I know there are similar solutions on the internet but I have not been abel to modify them to suit what I require.

i have also included examples of both sheets attached


Attachment 22445Attachment 22444

Hello Seacowdaz, any chance you might have posted this issue elsewhere??? I understand that you were given a heads up about cross posting a few weeks ago, in another forum, MrExcel wasn't it? Since it seems you dont really want to understand the importance of not cross posting without indicating that you have posted elsewhere, perhaps you need some time on the benches cooling your heels.