from multiple lists create one

[Cyril06]

Hello I have some lists with the exact same structure same numbers of columns et label.

Each list is an historic of one item (sorry for my bad english)

Into a "master" list I want each item with the lastest entry of itself... 

For example I have 3 cars to  rent ,blue red green, each one have is historic list and in the master list I want to see if the cars are rented or avalaible....

Do you know if it's possible to do directly into sharepoint?

[#2]

Hello @Cyril06! If you have to create a kind of Rent-a-Car App within SharePoint (or PowerApps) this is possible. Did you already create these lists so that one could see your relationships and IDs in that list construction? Would be helpful to get some screenshots of what you already have. Greets, Eva