Hello all,

It's been many years since I have been on here; I managed to figure out what my details were on the loast login attempt!

Here's my issue;

There are 9 workbooks (let's just call them book1 - book9 for now) that may be either in use or not at any point during the day. I'd rather not have to get people to come out of them so I can copy the data from the Usersname sheet of their workbook. Currently I have to have them all open on my machine to get my macro I recorded to work

I want to be able run a macro from within my master workbook which will look at the relevent sheet (Usersname!) in each of the workbooks, copy a range which I will specify (should be the same each time, but as an example let's use A2:Z150) and paste them into Allusers sheet in my master workbook. I want to paste them all into the same sheet, one after each other.

I'd like to bypass the notifications saying that there is already a list (for dropdowns) in my master spreadsheet and just use the lists that are in the master workbook by default rather than any validation that may be being copied over.

Hope that makes sense? I can't really post the files from work on here.

I've experimented with activating other workbooks and plugging filenames into other bits of code I've found online, but no luck so for.

Thanks everyone