Hi i have around 150 spreadsheets with the same data headings and layout in a folder on my computer, is it possible to copy all this data from each individual spreadsheet and combine it all in one big spreadsheet without having to do each one manually, i am using excel 2010 and i need idiot instructions as i am not an expert.
Can anyone help me please?