Hi,

I have a problem in that I have 18 workbooks, each with 3 tabs (Pre 18 yrs, 18-25 yrs, and Post 25 yrs). All of these workbooks are held within the same folder.

I want to be able to create a model that will at the click of a button import the data from each of these workbooks and consolidate them into one, with the same 3 tabs, but instead of 18 separate books with 18 lists, 1 book with 1 list for each tab.

I struggling to come up with a way to do this however, can anyone help?

Many thanks

C