Hi all

I have two questions which I hope someone can help with:

1) I have a list of companies (in Excel) which I have to make separate tabs for. Is there a way in which Excel can automatically create separate tabs for each company in the list?

2) Once the data is in the tabs, certain information from the tabs has to be replicated / linked into a summary tab. Is there an easier way than copy and pasting individual cell links from each tab? The information in the tabs is in the same cell in each tab, eg Company Name is always in B2

Hope this makes sense

Thanks

Mark