I have around 30 wookbooks (2003) which are not shared but they are the same (tabs columns same but number of rows are different in each tab). What is the best way to merge / copy,paste these into one. They are all in the same folder. I just need all the data from these workbooks into one

Your suggestions please

Mark