Create a view or form based on several lists?

I've done a heap of searching on this and haven't come up with a solution. It seems there used to be a tool called SharePoint designer which may have done the task but it doesn't seem to be an option...