It entirely depends on what you mean by "bring the workbooks in".

It is the end result that is of importance to the design.

For example, I have a Master workbook that probably has 28 or more external source files that it links to.

This master file sits between the source data and the eventual report that it produces. Source===>master====>report.

If you are having issues with charts and formatted data, there are many,many ways to resolve that.

Again, it depends on what the end result needs to be. If you just need to see the data from the 10 source workbooks, then importing them will do...

If you need to then spend time reformatting what you get...then perhaps another option involving linking is in order.

Lots of things make logical sense, but most logical is the one that best serves the purpose you need with minimal manual intervention...