Hi Guys,

I'm not sure if this is the right section but the database sections seemed to refer to access etc, rather than another workbook.

I have a workbook with maybe 25 tabs and it's getting a bit messy. The majority of these are tables full of data, with currently only 1 sheet I used to create a system which pulls data from the other sheets to create systems and prices.

Ideally, I'd like to split the 1 sheet used for systems and prices over multiple tabs, but I'm wary that this means even more sheets and also I don't want to bog down the whole book and make it run slowly.

My thought was to locate the data on another workbook and link them together but when I moved them over they initially worked, but when I closed the workbook and reopened, I got a load of #REF errors to the data.

Firstly, is this the best way to go about what I'm trying to achieve (simplify the systems and prices workbook and maintain speed) or is there another method? Secondly, how would it be best to set this up?

I watched a youtube video about using the data connection function, but this just seems to port the data across which defeats the objective I'm looking to do (simplify and maintain speed)

Any help/advice would be much appreciated!