Hi All!

Due to my limited knowedge of VBA (mainly picking through issues via google rather than wiritng a new code) I am struggling to compile an easy way of consolidating information from 4 workbooks into one single document. These are managed on a daily basis by 4 indivduals and I need a consolidated view of them for myself in another workbook.

What I need to do is copy the .DataBodyRange of a Table named 'Projects' from each of the 4 workbooks, then paste this data into my consolidated document which also contains a Table named 'Projects'. This data contains formulas and values which I want to keep in the same format in the consolidated view. Each document has the same columns, simply the amount of rows will extend as time goes by hence the reason behind using .DataBodyRange.

The documents are all saved in the same library but are not the only documents housed there.

Any help on this would be grealy appreciated so any further information you need please ask!

Many thanks in advance!